Parsing json without pagination data

[michaelshparber]

Hello,

I want to save the results of HTTP API call into SQL table

In the results there is pagination data: page_count, etc. that I don't need to save.

How do I parse ONLY what is inside "users" array below?

{
    "page_count": 1,
    "page_number": 1,
    "page_size": 30,
    "total_records": 1,
    "users": [
        {
            "id": "aaaaaaaaaaaaaaa",
            "first_name": "Mike",
            "last_name": "Mike",
            "email": "mike@mike.com",
            "type": 2,
            "pmi": 1111111,
            "timezone": "Asia/Jerusalem",
            "verified": 0,
            "dept": "",
            "created_at": "2020-04-07T16:02:18Z",
            "last_login_time": "2020-09-26T08:49:51Z",
            "last_client_version": "5.3.52640.0920(android)",
            "pic_url": "",
            "language": "",
            "phone_number": "+555 555555555",
            "status": "active"
        },
        {
            "id": "bbbbbbbbbbbb",
            "first_name": "Sam",
            "last_name": "Sam",
            "email": "sam@sam.com",
            "type": 2,
            "pmi": 2222222,
            "timezone": "Asia/Jerusalem",
            "verified": 0,
            "dept": "",
            "created_at": "2020-04-07T17:02:18Z",
            "last_login_time": "2020-09-25T08:49:51Z",
            "last_client_version": "5.3.52640.0920(android)",
            "pic_url": "",
            "language": "",
            "phone_number": "+555 77777777",
            "status": "active"
        }
    ]
}

[Pstork1 · Accepted solution]

Do a Parse Json step on the full result and then do a Select Action on "Users".  That will let you select the fields you want to grab out of the User's Array to add to another Array.  Or just use the "Users" dynamic content since that is the jSON you want.

[michaelshparber]

Excellent!

Thank you, @Pstork1