SB

Eric I am good. Thanks for your help.

Eric I was trying to use something like these.. Is that right way? I did not get results. To change hours to days I guess we just change 12hours to 2days (as an example)?

/api/v2/search?query=type:organization%20updated>12hours

/api/v2/search?query=form:8836099999499 custom_field_8836999980539:i_test_at_an_teset_test_test_level updated>12hours

Thanks Eric for the response. For organizations and the ticket form data, I am looking for a way to pull those were either updated or created within the last so and so hours or day(s)... 

Somehow, I cannot sort Organizations by updated_at desc or created_at desc

https://MyDomain.zendesk.com/api/v2/organizations?sort_by=updated_at&sort_order=desc

Also, how can we do the same for the ticket form api below?

https://MyDomain.zendesk.com/api/v2/search?query=ticket_form_id:8836099999499%20custom_field_8836999980539:i_test_at_an_teset_test_test_level

Since api gives 100 records in a page, I wanted to pull data updated in the last say 12 hours... Any suggestions? So if we can do this we can pull only the last updated Organizations and the form data every time our ETL pipeline runs...Thanks a lot for your assistance.

Hi All,

I need to create ETL to integrate form data to SQL tables. I am planning to use Azure DataFactory which has connector for Zendesk and also Rest API connector. I have been provided URL like this https://DOMAIN.zendesk.com/api/v2/search?query=ticket_form_id:553604652496. Domain is where our Zendesk domain name goes in and the form_id id is numbers. Is this the URL I should be using to get to the data populated by the form users? Also form has conditional field and based on the inputs users are directed to the right form/form fields. My question is the url the right url (with my domain name) to get to the data from our ETL tool? How can I find the correct api for GET Method to be able to pull the end users' data populated from the above form?

Thanks,

SB

Hi All,

I need to create ETL to integrate form data to SQL tables. I am planning to use Azure DataFactory which has connector for Zendesk and also Rest API connector. I have been provided URL like this https://DOMAIN.zendesk.com/api/v2/search?query=ticket_form_id:553604652496. Domain is where our Zendesk domain name goes in and the form_id id is numbers. Is this the URL I should be using to get to the data populated by the form users? Also form has conditional field and based on the inputs users are directed to the right form/form fields. My question is the url the right url (with my domain name) to get to the data from our ETL tool? How can I find the apis for GET Methods to be able to pull data populated from the form?

Thanks,

SB