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
    February 14, 2022 15:56

    @jessica - Any updates on this?

  • Richard Lane commented
    February 01, 2022 15:14

    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
    November 10, 2021 22:04

    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
    August 12, 2021 18:12

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

  • Admin
    Michael Schmidt commented
    March 02, 2021 07:43

    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
    February 25, 2021 17:27
    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
    February 02, 2021 19:37

    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