AnsweredAssumed Answered

Json document response not splitting correctly

Question asked by akhajooei272797 on Oct 17, 2016
Latest reply on Oct 21, 2016 by akhajooei272797

Hi,

 

I am retrieving a json response from an endpoint and I use the following to import the profile into Boomi:

 

{
    "data": [
        {
            "type": "assignments",
            "attributes": {
                "grovo_id": "asfd98928yr2quihef",
                "email": "bobby@test.com",
                "employee_id": null,
                "first_name": "Bobby",
                "last_name": "Test",
                "created_at": "2015-01-09 21:32:28",
                "trainings": [
                    {
                        "id": "17101",
                        "name": "T",
                        "status": "Not Started"
                    }
                ]
            }
        },
        {
            "type": "assignments",
            "attributes": {
                "grovo_id": "jp23r8gh938rghpuef",
                "email": "fed@test.com",
                "employee_id": null,
                "first_name": "Federico",
                "last_name": "Ulfo",
                "created_at": "2014-11-18 22:27:37",
                "trainings": [
                    {
                        "id": "15483",
                        "name": "API TEST",
                        "status": "Complete",
                        "score": "20",
                        "pass_fail": "Pass",
                        "completed_at": "2015-10-19 23:22:57"
                    },
                    {
                        "id": "22577",
                        "name": "BOX",
                        "status": "Complete",
                        "score": "40",
                        "pass_fail": "Fail",
                        "completed_at": "2015-11-03 01:02:04"
                    },
                ]
            }
        }
    ],
    "meta": {
        "pagination": {
            "total": 3,
            "count": 3,
            "per_page": 10,
            "current_page": 1,
            "total_pages": 3
        }
    },
    "links": {
        "first": "https://api.grovo.com/users?page=1",
        "last": "https://api.grovo.com/users?page=3",
        "previous": "https://api.grovo.com/users?page=1",
        "next": "https://api.grovo.com/users?page=2"
    }
}

 

In a data process shape I use the email element to split the documents. However I can see at least two different emails in my response but I only get one document and the split does not work properly.

 

I would really appreciate your help on this.

 

Thank you!!

Outcomes