HI,
I have json file ,In json file at the end of the json we have next command ,if we have a next command in json file we have to store the variable .the loop continuous till we get json file ,the json file should be save in individual file in text for for each link .
I have atttached the json file
Kindly Help.
Deserialize_Json.txt (2.1 MB)
so if next node is there in json you would use that url to make the next call?
or does the url stay constant
"__next" : "https://api10preview.sapsf.com/odata/v2/OnboardingCandidateInfo?$skiptoken=eyJzdGFydFJvdyI6MTAwMCwiZW5kUm93IjoyMDAwfQ=="
If you have to use the url from the next you can check if its null if not fetch the url and make a request
Example in the json sheet i have share at last we have url after with that url we need to HTTP request with that url and after getting response that response we have to store it in txt file in that txt file at last next will be availabe take that url and repeat the the process untill we find the next in json .for each link we have to store the seprate txt file .
try something like this

edit: use index to determine first run of loop based on that use your initial url after that you can switch to the _next token url. index can be asssigned from properties of do while activity

As party answered in your other topic
- Do while Loop
- Call endpoint
- Save Response
- Deserialize JSON
- Check __next presence
- Extract next value
Loop condition
Precense Check:
YourJObjectVar.ContainsKey(“___next”)
A combined approach of presence Check and value extraction
YourJObjectvar.SelectTokens("___next").Select(function(x) x.Value(of String)).FirstOrDefault()
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.