AnsweredAssumed Answered

Help with filters..

Question asked by FredrikCronholm77140603 on Jun 14, 2016
Latest reply on Jan 18, 2017 by norre01

Hi!

I can't figure out how to extract certain parts of my JSOn response..I need to get the id's that now has the values 22,23,24

[

    {

        "sourceId": "S70",

        "description": "SAAB Försäkring",

        "policyStartDate": "2016-06-15",

        "offerStatus": "CREATED",

        "productName": "Folksam personbil",

        "customerSsn": "196002116926",

        "reference": "MF-1056859-456",

        "agreementSystemId": "S70",

        "price": 304,

        "salesAgent": {

            "firstName": "Mock",

            "lastName": "Mocksson",

            "emailAddress": "mock.mocksson@folksam.se",

            "phoneNumber": "0705296997",

            "id": "1337",

            "salesAgentNumber": "123"

        },

        "id": 24,

        "createDate": "2016-06-08",

        "salesOpportunityId": 10

    },

    {

        "sourceId": "S70",

        "description": "NRL537 VW personbil",

        "policyStartDate": "2016-06-15",

        "offerStatus": "CREATED",

        "productName": "Folksam personbil",

        "customerSsn": "196002116926",

        "reference": "MF-1056859-111",

        "agreementSystemId": "S70",

        "price": 1404,

        "salesAgent": {

            "firstName": "Mock",

            "lastName": "Mocksson",

            "emailAddress": "mock.mocksson@folksam.se",

            "phoneNumber": "0705296997",

            "id": "1337",

            "salesAgentNumber": "123"

        },

       "id": 23,

        "createDate": "2016-06-08",

        "salesOpportunityId": 10

    },

    {

        "sourceId": "S70",

        "description": "NRL517 VW personbil",

        "policyStartDate": "2016-06-15",

        "offerStatus": "CREATED",

        "productName": "Folksam personbil",

        "customerSsn": "196002116926",

        "reference": "MF-1056859-789",

        "agreementSystemId": "S70",

        "price": 4404,

        "salesAgent": {

            "firstName": "Mock",

            "lastName": "Mocksson",

            "emailAddress": "mock.mocksson@folksam.se",

            "phoneNumber": "0705296997",

            "id": "1337",

            "salesAgentNumber": "123"

        },

        "id": 22,

        "createDate": "2016-06-08",

        "salesOpportunityId": 10

    },

    {

        "sourceId": "S70",

        "description": "NRL537 VW personbil",

        "policyStartDate": "2016-06-15",

        "offerStatus": "CREATED",

        "productName": "Folksam personbil",

        "customerSsn": "196002116926",

        "reference": "MF-1056859-123",

        "agreementSystemId": "S70",

        "price": 404,

        "salesAgent": {

            "firstName": "Mock",

            "lastName": "Mocksson",

            "emailAddress": "mock.mocksson@folksam.se",

            "phoneNumber": "0705296997",

            "id": "1337",

            "salesAgentNumber": "123"

        },

        "id": 21,

        "createDate": "2016-06-08",

        "salesOpportunityId": 10

    }

]

Outcomes