PHP - Parse JSON Response

Question

I am trying to parse this JSON CURL response. I have tried json_encode, json_decode, serialize, unserialize. This is the raw response from CURL:

    {
    d: "[{"BranchName":"D7","BranchCode":"D7","Available":"0","StorageOnlySalesCenterMsg":null,"IsRestricted":false},
         {"BranchName":"A4","BranchCode":"A4","Available":"0","StorageOnlySalesCenterMsg":null,"IsRestricted":false},
         {"BranchName":"525A","BranchCode":"525A","Available":"0","StorageOnlySalesCenterMsg":null,"IsRestricted":false}]"
    }

I would like to just do a simple foreach statement like this:

foreach($json as $data){
    echo 'Branch: ' . $data['BranchName'] . ', ';
}

Result:

Branch: D7,
Branch: A4,
Branch: 525A,

Any suggestions?

The JSON is invalid. It looks like an attempted JSON string inside of another JSON string, but since the inside quotes are not escaped, it's breaking the format. Talk to whoever you're getting the response from, and have them fix it. — aynber
– aynber, Commented Jul 22, 2021 at 19:46

digijay · Accepted Answer · 2021-07-22 20:18:37Z

1

As aynber already pointed out, this would be a valid representation of your json object:

{
"d": [{
        "BranchName": "D7",
        "BranchCode": "D7",
        "Available": "0",
        "StorageOnlySalesCenterMsg": null,
        "IsRestricted": false
    },
    {
        "BranchName": "A4",
        "BranchCode": "A4",
        "Available": "0",
        "StorageOnlySalesCenterMsg": null,
        "IsRestricted": false
    },
    {
        "BranchName": "525A",
        "BranchCode": "525A",
        "Available": "0",
        "StorageOnlySalesCenterMsg": null,
        "IsRestricted": false
    }
]
}

answered Jul 22, 2021 at 20:18

digijay

1,3764 gold badges17 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP - Parse JSON Response

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related