PAGINATION - DATA STREAM (Item Path)

gj1
Kilo Expert

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.

find_real_file.png
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"
      }
    ]
1 ACCEPTED SOLUTION

gj1
Kilo Expert

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.

View solution in original post

6 REPLIES 6

gj1
Kilo Expert

Hi Shui
i just kept the values that are being fetched, the following screenshot should help you

Regards
GJ

gj1
Kilo Expert

find_real_file.png