PAGINATION - DATA STREAM (Item Path)

[gj1]

Hi Community
We are using a Data Stream action to leverage the Pagination concept in Flow designer as we are getting data more than 5mb from the source, so we did set up everything but the data that is being fetched doesn't have any KEY in it where we can use it in ITEM PATH of the Splitter step, and we are receiving only arrays.

We tried all the possibilities by giving all arrays as a combination like $.name.id.A.B.C.D but even then it didn't help, So any suggestion or solution to this would be of great help to me.

This is the response we are getting into the system through REST API :

[
  {
    "email2": "__USER_EMAIL_2__",
    "salesrepId": "",
    "name": "xyz",
    "id": "00000000-0000-0000-0000000000000000",
    "active": 1,
    "username": "__USER_USERNAME__",
    "email": "__USER_EMAIL__",
    "groups": [
      {
        "name": "abcd",
        "id": "00000000-0000-0000-0000000000000000"
      },
      {
        "name": "qrst",
        "id": "00000000-0000-0000-0000000000000000"
      }
    ]

[gj1 · Accepted solution]

Hi Community , we have a solution for the above query that, I have posted and sharing his as it might help someone someday.
we didn't pass anything in the item path except the $ sign.
My splitter step:

In script parser step we declared a variable and passed all the arrays we are fetching into it (we can refer the above screen shot i have posted)

And in outputs i have declared all my  variables

we have set the pagination as per the requirement and it did execute.

[Sandy1]

Hi , The images are not visible. can you please share it again. Thanks in advance

[Sandy1]

Hi, The images are not visible, can anyone share them again 

[Shui]

Hi gj,

Thank you for this post and solution. My data stream action is very similar to yours. I also have an Array.Object in the action output (like groups in your action) and I have same code in the script parser step, however, my array.object field was not populated correctly. Did you do anything additional to this field? Can you please expand that field in Edit Output Mode? Thank you!