1

How to make multiple requests to When I Work (WIW)

sohail sarwar

December 28, 2018 23:39

None

Follow

We have data coming from When I Work that is paged (page=X, and more=true/false) in the JSON.  They have said we need to make multiple requests in order to retrieve all the data.  Do you have the ability to iterate over multiple requests?

 

When I Work suggested to make multiple requests like the following to return 200 objects of 559 available...  Basically, I need it to return all the objects.

https://api.wheniwork.com/2/requests?start=2018-10-01&end=2019-12-31&page=0
https://api.wheniwork.com/2/requests?start=2018-10-01&end=2019-12-31&page=1
https://api.wheniwork.com/2/requests?start=2018-10-01&end=2019-12-31&page=2

 

 

• Facebook
• Twitter
• LinkedIn

5 comments

• 0
  
  Janice Janczyn December 31, 2018 15:37

  Hi Sohail,

  Please see Datasources with Multiple Pages for a description of how to retrieve multiple pages for a datasource query. You will need to know how many pages you need to return--does the API tell you the total number of records to be returned? Also, see Working with Dynamic Datasources for further details on working with variables in datasource queries.

  Thank you,
               Janice

• 0
  
  sohail sarwar December 31, 2018 17:14

  Janice,  How do I add the content to the api url.  I need to add page 0, page 1 and page 2

   

  https://support.klipfolio.com/hc/en-us/articles/218946328-Data-sources-with-multiple-pages-

   

• 0
  
  sohail sarwar December 31, 2018 17:16

  How do I add the Map command to the three url's above?  Can you help with the syntax, please?

• 0
  
  Kalyani Khandelwal January 02, 2019 07:10

  Hi Sohail, 

  First, you will need to create a variable for page number. Eg. pageVar and give it value=1

  Then add the variable to your API query : https://api.wheniwork.com/2/requests?start=2018-10-01&end=2019-12-31&page={prop.pageVar}

  Use the same variable in the MAPFLAT function to loop through the number of pages. 

  MAPFLAT(ARRAY(1,2,3),"pageVar",Select the data from the dynamic datasource you just created in the third part) 

  Hope this helps!

  Kalyani

• 0
  
  sohail sarwar January 03, 2019 16:11

  Hi Kalyani

  Can you help me with the exact syntax in Klipfolio.  Would the following be correct?

   

  https://api.wheniwork.com/2/requests?start=2018-10-01&end=2019-12-31&page={prop.pageVar}&MAPFLAT(ARRAY(1,2,3),"pageVar"