Data extraction via API | Community
Skip to main content

Data extraction via API

  • January 16, 2024
  • 1 reply
  • 0 views
TC100

Hi Folks,

I have a python script that extracts ZenDesk data via the below code:

 response = requests.request("GET", url, auth=(user, pwd), headers={"Content-Type": "application/json"})

data = response.json() 
results = pd.json_normalize(data['results']) 

May I know why some of the fields returned are in numeric code form rather than in description format.

For e.g. instead of its description of "VCC/Inbound", a code value of 1685189953525 is returned

Can advise how to resolve this, pls?

 

regards

Tuck Chong

    1 reply

    Luiz16
    • Luiz16
    • January 25, 2024

    Hello @tc100

    For ticket fields, Zendesk has two types (1) standard (2) custom fields

    Every time your request response brings to you a numeric code, means you are getting a custom field. When brings to you as a description format, means you are getting standard fields.

    With this endpoint, you can get a list of all custom fields from your account:

    https://{subdomain}.zendesk.com/api/v2/ticket_fields.json

    You can create a table to make a from/to of custom field ID vs. field title

    Also, you can take a look here for more information about how to use custom fields via API : 

    https://developer.zendesk.com/api-reference/ticketing/tickets/ticket_fields/#list-ticket-fields

    Hope this helps you!

    Terms & ConditionsCookie settingsAccessibility statement