Recent searches

No recent searches

Data extraction via API

image avatar

TC

Posted Jan 16, 2024

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

0

1

1 comment

Date
    image avatar

    Zendesk (Teste)

    Hello TC

    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!

    0

    Please sign in to leave a comment.

    Didn't find what you're looking for?

    New post