Hi Everyone,
There was a small issue/logic I stuck in, and your assistance would be greatly appreciated.
I have an API(dummy) below
https://api.subapi.com/v1/lists/111/contacts/all?count=500&vidOffset=16566401
In this API i want to keep changing the vidOffset value with new one to get the another lists of data.
But when I'm adding a new value its not replacing the old one, instead getting appended with the old one and it coming like this
https://api.subapi.com/v1/lists/111/contacts/all?count=500&vidOffset=1656640118161151
could you please help me on this how I can handle it?
So my logic is if there is has-more = 1 then start the loop and append the vid-offset to the url.
So the first logic is :
1. [JSON_Name] = "has-more" OR [JSON_Name] = "vid-offset" => its giving me the above screenshot result.
2. Then in the formula tool I'm using two logic:
(a) COLUMN Name = offset =>
[JSON_Name]="vid-offset" then [JSON_ValueString]
else Null()
endif
(b) Coulumn Name = api => https://api.subapi.com/v1/lists/111/contacts/all?count=500&vidOffset=
[api]+[offset]
Solved! Go to Solution.
I got the solution for this.
Instead of using [api]+[offset] in the formula tool, I used the complete url string and then append the [offset] variable to it.
'https://api.subapi.com/v1/lists/111/contacts/all?count=500&vidOffset='+[offset]
:)
Can you please attach your Workflow for reference?