Ideas for Arc XP

Reporting: Developer API for Arc Subs retail (products / prices) that can be used to get product / plan information for reporting and internal uses

Currently there is not a way to lookup a product or price information by SKU or CODE. We would like to be able to use the price SKU to look up term and price information. We would like a way to see all price SKUs for a particular product.

We would like to know if a particular price SKU is used (referenced by) an offer.

Arc's private api has some search and capabilities but are not accessible using a developer token.

https://dmn.arcpublishing.com/retail/private/v1/product?sort=name&sortDirection=ASC&size=1000&search=active%3Dtrue

  • Richard Lane
  • Jan 6 2021
  • Planned
  • Attach files
  • Richard Lane commented
    14 Feb, 2022 03:56pm

    @jessica - Any updates on this?

  • Richard Lane commented
    1 Feb, 2022 03:14pm

    Jessica - This will not work for all of our needs. We need to be able to get offer details by priceCode or SKU.

    We are developing a cancelation workflow and need to compare current price code to a known list of other offers.

    Thoughts on how to achieve this without having to sync a DB table on our side using your Private arc retail API mentioned in original request?

  • Admin
    Jessica Cavallo commented
    10 Nov, 2021 10:04pm

    Richard - This should now be available as part of the data extract framework. https://redirector.arcpublishing.com/alc/arc-products/subscriptions/user-docs/arc-subscriptions-data-extraction-framework/

    Please let me know if you need any more details.

  • Admin
    Jessica Cavallo commented
    12 Aug, 2021 06:12pm

    This information will be available as part of the new extracts.

  • Admin
    Michael Schmidt commented
    2 Mar, 2021 07:43am

    Thank you, Richard. This is great! We've got the information covered, and will follow-up with a timeline for when this work might fit.


    Best,

    -Michael

  • Richard Lane commented
    25 Feb, 2021 05:27pm
    1. Yes, I believe the exact name is priceCode.

    2. What you return for the current private pricing/strategy API endpoint would be great.

      1. Example:

      {"createdOn":1612454175000,"createdBy":null,"modifiedOn":1612454186000,"modifiedBy":null,"deletedOn":null,"id":1294,"amount":"17.29","billingCount":1,"billingFrequency":"Month","durationCount":1,"duration":"UntilCancelled","taxInclusive":false}],"publishedOffers":{"274":"DN FEB TRI DAY SALE Rev 2","275":"DN Valentine Sale 2021","295":"DN Ad Blocker Meter 02232021","296":"DN Coronavirus Meter 02232021","297":"DN Incognito Meter 02232021","298":"DN Interactives Meter 02232021","299":"DN Premium Content Meter 02232021"},"taxInclusive":false}


    3. Like the example above, it should include rates array.

    4. Like the example above, it should include published offers price is used on.

      1. We have the price code via reports / checkout currently so that is what we would use as a reference.

    5. Also, a way to get all published priceCodes (not just a specific one)

    Sorry for the late reply.

  • Admin
    Michael Schmidt commented
    2 Feb, 2021 07:37pm

    Hi Richard! I'm new to the team, and had a few follow-up questions for you. Can you confirm I've got the details right?

    1. It would be great to have a way to look up a product or price, by SKU or Code

    2. The results of that call should return term and price information about the SKU or Code

    3. It would be great to see all prices for a particular SKU

    4. Additionally, you would like a way to know if a SKU is used by an offer

      1. One question about this -- do you want to search by price and SKU, or just SKU?

    Thank you for submitting the idea to us!


    Best,

    -Michael