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: 
Anonymous
Not applicable

ActiveNet API using paging parameters to retrieve data. How would this be entered in the tRESTClient?

By default this API returns 1 page at 50 records per page.  You can control this by setting the response header to include the following format:

 

page_info: {"total_records_per_page":50, "page_number":1}

 

 

Other parameters can be added such as total_records and total_page.  The issue is how to translate this syntax into the configuration.  I have attempted to enter this into the advanced settings in the HTTP Headers section but always get errors of some kind including "invalid pagination parameter" which is the closet.  I'm not able to get even a single parameter to work such as trying to just affect the "total_records_per_page":10 for example.

 

Has anyone needed to do this or is there another avenue?

 

Results of the current test using Error row to tLogRow:

 

[statistics] connecting to socket on port 3472
[statistics] connected
400|{"headers":{"response_code":"0015","response_message":"Invalid pagination parameter"},"body":[]}
[statistics] disconnected

Job jActiveNetMembers ended at 17:37 03/10/2018. [exit code=0]

 

Here's the setup:

 

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

This was resolved by another topic discussion on how to enter the complex sequence:

 

"{
\"method\":\"list_questions\",
\"params\":[
\""+context.SessionKey+"\",
\"378563\"],
\"id\":\"1\"
}"

View solution in original post

1 Reply
Anonymous
Not applicable
Author

This was resolved by another topic discussion on how to enter the complex sequence:

 

"{
\"method\":\"list_questions\",
\"params\":[
\""+context.SessionKey+"\",
\"378563\"],
\"id\":\"1\"
}"