Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Note: I am unable to insert/upload images
Following is the sample JSON response from tRESTClient . I am able to get "maxResults": 500. How to get all the results by iterating programmatically.
tJava_1 ---on Subjob OK --->tLoop ---- Iterate ----> tJava_2 --on Component OK --> tRESRClient ---row2--> tExtractJSONFields---row1--->tJavaFlex
what should be java code/settings in tJava_1, tLoop, tJavaFlex components
{
"expand": "schema,names",
"startAt": 0,
"maxResults": 500,
"total": 1603,
"issues": [
{
"expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
"id": "6978451",
"self": "https://onejira.XXXX.com/rest/api/2/issue/6978451",
"key": "ABC-4",
"fields": {
"customfield_51618": null,
"resolution": null,
"customfield_50402": null
}
}
{
"expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
"id": "6978452",
"self": "https://onejira.XXXX.com/rest/api/2/issue/6978452",
"key": "ABC-5",
"fields": {
"customfield_51618": null,
"resolution": known issue,
"customfield_50402": null
}
}
]
}
regards
uday
Hi you have to query a first time to get the total here 1603 then you can divide by 500 so here you have 4 run of 500 and you change the 'start at' value , for each iteration to get the next 500 records
Thanks for the answer. I got the logic, data has to be fetched as described below:
1st iteration:
"startAt": 0
2nd iteration:
"startAt": 500
3rd iteration:
"startAt": 1000
4th iteration:
"startAt": 1500
But I want to achieve programmatically, in this example we know that total records are 1603. In future if total records are >2000 job has to run 5th time.
So for achieving same I am using above mentioned job sequence.
tJava condition:
globalMap.get("startAt")<globalMap.get("total")
tJavaFlex settings:
globalMap.put("total", row1.total);
int startAt = (500 * ((Integer)globalMap.get("tLoop_1_CURRENT_ITERATION")).intValue()) -500;
globalMap.put("startAt", startAt);