Hi, I am new here and trying to get data from my backoffice system and enter that data into another system.
Here are the basic steps.
- Trigger when a Project is closed in the backoffice system
- Get some customer details of the Project, such as customer name, email and address
- Use a webhook that GET all customers because I need the customer uniqueID, that’s not supplied from step 2. (will need the customer uniqueID in later steps)
So on step three, the webhook gets customer data but only the first record. Then looking at the backoffice api documentation, the returned data is an array of objects. If I use something like postman and run the GET webhook, it returns the entire data set not just one record.
So my question is, how do I get all the records in zapier and then search them to match name, address and give me the customer unique ID for the matched record?
Thanks for any help!