Qlik Rest Connector Pagination

[DrB1]

I'm new to using API's and I don't understand pagination enough to get all the data from Planning Center People. I connect, and can get data but depending on the settings I choose for pagination, I get anywhere from 25 to 1632 of 6507 records. I don't understand what I should be doing. The API Explorer Planning Center provides for developers (I'm a wannabe developer) gives this server response:

"root":{ 4 items

       "links":{ 2 items

                "self": "https://api.planningcenteronline.com/people/v2/people"

                "next": "https://api.planningcenteronline.com/people/v2/people?offset=25"

}

"data":[   25 items

0:{...    .................... to 25.......

"included":[] 0 items

"meta":{ 8 items

      "total_count": 6507

      "count": 25

               "next":{...}1 item

               "can_order_by":[...] 20 items

               "can_query_by":[...] 29 items

               "can_include":[...] 15 items

               "can_filter":[...] 3 items

                "parent":{...} 2 items

}

}

I interpreted this to mean I should use Pagination one of these - I've tried both and cannot get all the 6507 records:

• Offset:
• 'Start' parameter name: offset
• 'start' initial value: 0
• 'count' parameter name: 'count'
• ''count' initial value: 25
• 'total records' path: root/meta/total_count
• Next URL
  • 'next url' path: root/meta/next

I tried various "offset" settings but simply cannot get this to work. Any help anyone can provide would be most appreciated. - super indebted!!

[DrB1]

Oh, @marksouzacosta , this may be exactly what I need. I will try it and let you know! Thank you so much! I will also check out the video about looping urls. Thank you !!!