PHP - get JSON array name from nested JSON (first line)

Question

Sorry, brand new to JSON, need some help.

I receive the following JSON array as a result from my API and need to get the very first string of numbers (= entity ID), which just so happens to not be a key or value. How can I get only that number in PHP while ignoring everything else?

Result:

"aa7a5d31-6114-47b5-a30c-27ad724cf212"{  // <-- this is what I need
   "statusCode":200,
   "effectiveUri":"https:\/\/workmail.eu-west-1.amazonaws.com",
   "headers":{
      "x-amzn-requestid":"long-number-code",
      "content-type":"application\/x-amz-json-1.1",
      "content-length":"49",
      "date":"Mon, 28 Jun 2021 13:46:18 GMT"
   },
   "transferStats":{
      "http":[
         [
            
         ]
      ]
   }
}

Thanks

Sadly not much I can do about it, that's the data that comes back and I have to deal with -.- — Armitage2k
– Armitage2k, Commented Jun 28, 2021 at 14:01
Whoever did it like that needs to fix it - have given a bodge for an answer however — pee2pee
– pee2pee, Commented Jun 28, 2021 at 14:04
If you were told that you would get JSON, then the appropriate way of “dealing” with this is to reject it with an error message or exception or something, after the attempt to decode it as JSON failed. — C3roe
– C3roe, Commented Jun 28, 2021 at 14:04
New to JSON, but very experience in judging the guilty ;) Nope, this is the response I get from my API call, although I am sure there is a roundabout way to get that ID via 2 more calls, which is inefficient to say the least. — Armitage2k
– Armitage2k, Commented Jun 28, 2021 at 14:14

pee2pee · Accepted Answer · 2021-06-28 14:03:24Z

2

<?php
$json = '"aa7a5d31-6114-47b5-a30c-27ad724cf212"{
   "statusCode":200,
   "effectiveUri":"https:\/\/workmail.eu-west-1.amazonaws.com",
   "headers":{
      "x-amzn-requestid":"long-number-code",
      "content-type":"application\/x-amz-json-1.1",
      "content-length":"49",
      "date":"Mon, 28 Jun 2021 13:46:18 GMT"
   },
   "transferStats":{
      "http":[
         [
            
         ]
      ]
   }
}';

$result = str_replace('"','',explode("{",$json)[0]);
echo $result;

answered Jun 28, 2021 at 14:03

pee2pee

3,79711 gold badges66 silver badges147 bronze badges

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

Comments

Tangentially Perpendicular · Accepted Answer · 2021-06-28 14:08:54Z

0

Use a regular expression:

$json = '"aa7a5d31-6114-47b5-a30c-27ad724cf212"{
   "statusCode":200,
   "effectiveUri":"https:\/\/workmail.eu-west-1.amazonaws.com",
   "headers":{
      "x-amzn-requestid":"long-number-code",
      "content-type":"application\/x-amz-json-1.1",
      "content-length":"49",
      "date":"Mon, 28 Jun 2021 13:46:18 GMT"
   },
   "transferStats":{
      "http":[
         [
            
         ]
      ]
   }
}';

preg_match('/^"(.*?)"/', $json, $matches);
echo $matches[1];

answered Jun 28, 2021 at 14:08

Tangentially Perpendicular

5,4364 gold badges15 silver badges34 bronze badges

Collectives™ on Stack Overflow

PHP - get JSON array name from nested JSON (first line)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related