Zuora
  • 19 Apr 2024
  • 1 Minute to read
  • Dark
    Light
  • PDF

Zuora

  • Dark
    Light
  • PDF

Article Summary

Zuora API

API Documentation Link


Configuration Parameters

Any instance where an entry in the below configuration has a leading $ represents a parameter that needs to be replaced with a static value.

Parameters in this document:

  • $client_id and $client_secret - The tokens associated with an Authenticated User in Zuora, which can be exchanged for the access token that will be used to make API calls. Documentation on how to Authenticate a User can be found here.
  • $access_token - The Access Token will provide access to the Zuora API. Documentation on how to exchange a Client ID and Client Secret for an Access Token can be found here.
  • $resource_name - The endpoint, or resource, that you would like to ingest into Panoply.

API Resources

For a list of API Resources available for Zuora, please refer to the list of endpoints found here, where each endpoint can be seen as a dropdown on the lefthand menu, starting with the Products section.


Connector configuration

  • Base url: https://rest.sandbox.eu.zuora.com/v2/$resource_name
  • Method: GET
  • URL Parameters: page_size=99
  • Headers: {"Content-Type":"application/json"}
  • Destination: zuora_$resource_name

Destination table naming convention is ultimately up to you as the data owner. One common structure used for this API is zuora_$resource_name (e.g. when collecting the Products resource, using the Destination of zuora_products)

Authorization

  • Authorization: Bearer Token
  • Token: {access_token}

Variables

Variable nameVariable value
client_id$client_id
client_secret$client_secret
access_token$access_token

Pagination

  • Enable: Checkbox.png
  • Get next page value: Dynamic (next page value included in the response)
  • Next page key in response: next_page
  • Use next page value: As a URL parameter value
  • URL/body key: cursor
  • Stop iterating when: No next page in response

Refresh access token

  • Enable: Checkbox.png
  • URL: https://rest.sandbox.eu.zuora.com/oauth/token
  • Method: POST
  • POST data: {"client_id":"{client_id}","client_secret":"{client_secret}","grant_type":"client_credentials"}
  • Headers: {"Content-Type":"application/x-www-form-urlencoded"}
  • Access Token response key: access_token
  • Use Bearer authentication: Checkbox.png
  • Error status codes: 401; 403

Advanced Settings

  • Data key: data

Was this article helpful?