Hello, I have a search step that only returns the values of the first object. The output of the search step if done using an actual API call would be:
output: [{foo1: bar}, {foo2: bar}, etc]
Doing this call search using a JS fetch wouldn’t really be possible as it requires a cookie, hence why using Zapier for the OAuth is really useful for automation. However Zapier only outputs the information of the first object in the array, and I cannot find a way to be able to loop through this step as there is no way of referencing it without referencing an actual preview which will not loop at all.
I am aware that if the creator of the integration was to have it as an array of one object which contains all the results it would work, like:
[case: {{foo1: bar}, {foo2: bar}, etc}]
But this isn’t possible to request for as it would potentially break other functionality. Is it literally not possible? Trying to have a code step doesn’t really work as I can’t specify an input without referencing the search, and that will only see it as one item. Are there any ways around this, perhaps using tables?
Any help would be appreciated!
Looping through array of objects
- Beginner
- 2 replies
What search step are you using?
Depending on the search step and the integration, it may be possible to do what you're looking for within the integration. Otherwise, it may be possible using a raw API call using a Webhooks step.
+14- Zapier Orchestrator & Solution Partner
- 34032 replies
Hi
I’ve seen this behavior before and it usually requires using a Code step, which supports inputs, to make the API request, then you can handle the response however you’d like.
https://zapier.com/apps/code/integrations#help
- Beginner
- 2 replies
Hi
I’ve seen this behavior before and it usually requires using a Code step, which supports inputs, to make the API request, then you can handle the response however you’d like.
https://zapier.com/apps/code/integrations#help
Thanks for the reply. Unfortunately I can’t do this on a consistent basis. I have tried doing this and it does work, however, the integration I am using requires a cookie for an API call, which is generated from my OAuth user, and Zapier has no way of getting the `authorization` cookie from my current session. So when I have done this, I have passed in a hard-coded cookie into a JS fetch request.
For one off instances this works perfectly, and is exactly how I want to return my information, however due to the cookie required in the request headers, it isn’t a permanent solution.
Is there any other way around this that you are aware of?
- Beginner
- 2 replies
What search step are you using?
Depending on the search step and the integration, it may be possible to do what you're looking for within the integration. Otherwise, it may be possible using a raw API call using a Webhooks step.
Hello, thanks for replying. I am using a private integration, I am aware that a search step for google sheets has a return multi-line or something like that, which will allow multiple returns. Is that what you are suggesting?
I think the raw API call won’t work as the API call requires a `authorization` cookie, so I can hard code it, but in terms of repeatability and automation, it isn’t a viable option.
I have suggested to the owner of the integration, a true/false flag for return multi line item, which would then on true return an array with one object, filled with objects, which would work I believe. And then false would return the previous functionality. However the owner wasn’t keen on changing and said it was possible without any explanation.
+14- Zapier Orchestrator & Solution Partner
- 34032 replies
What app API endpoint are you trying to user? (link to documentation)
+3If you are facing the issue of expiration of cookie then, you can add a login step in your zap, where you can make an api post request using the login credentials to the desired app login endpoint, and you will receive the cookie in response, you can use the cooke in your js code step.
This way when ever your zap runs, it will get a new cookie token from the login step and use that in the following js step.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.