Data extraction via API



Data ultimo post: 16 gen 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 commento

      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


      Accedi per lasciare un commento.

      Non hai trovato quello che cerchi?

      Nuovo post