Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
kavi01
Contributor
Contributor

Looping list of value API CALL

Dear Experts,

I receive from my trestclient by API get method a list of values that can go from 0 value to xxxx, I would like to be able to group them by 10, 100, 500 so that my next processing can play them on a loop

I am currently using the TFlowToIterate block with tJavaFlex for get information but this method only allows me to transmit one value at a time

Thanks for your help

0693p00000BW3UJAA1.png tJavaflex :

0693p00000BW3SNAA1.png 

Example of a list of values:

44565

48965

45697

..

Labels (4)
4 Replies
Anonymous
Not applicable

You can group the value and trigger the next processing only when the number of line is 50,100, 150 ..., the question is how do you pass the value to the API calling? Does it accept a group of value at one calling?

 

Regards

Shong

kavi01
Contributor
Contributor
Author

Hello Shong,

 

Thanks for the reply, the number of line depend of the query, i pass value as an argument to the API like (44565,48965,45697)

If it's too long, the HTTP query fall in lenth issue error.

Anonymous
Not applicable

@so cocolo​ , Here is a scenario showing how to append a list of value and achieve batch processing.

0693p00000BWhvKAAT.png0693p00000BWhvFAAT.png0693p00000BWhvAAAT.png 

I use runIf connector to trigger the next processing for 10 values in a time.

 

Please try and let me know if you have any questions.

 

Regards

Shong

kavi01
Contributor
Contributor
Author

Hello Song,

 

Thanks you very much for your proposal, it's working for me 🍻