PHPize Online / SQLize Online  /  SQLtest Online

<?php $json = '{"d":{"results":[{"__metadata":{"id":"http://dms.pelsrijcken.nl/matter/24/70000166/_api/Web/GetFileByServerRelativeUrl('/matter/24/70000166/Documents/70000166/WWFT/PPP-verklaring (NL) (2020).docx')","uri":"http://dms.pelsrijcken.nl/matter/24/70000166/_api/Web/GetFileByServerRelativeUrl('/matter/24/70000166/Documents/70000166/WWFT/PPP-verklaring%20(NL)%20(2020).docx')","type":"SP.File"},"Author":{"__deferred":{"uri":"http://dms.pelsrijcken.nl/matter/24/70000166/_api/Web/GetFileByServerRelativeUrl('/matter/24/70000166/Documents/70000166/WWFT/PPP-verklaring%20(NL)%20(2020).docx')/Author"}},"CheckedOutByUser":{"__deferred":{"uri":"http://dms.pelsrijcken.nl/matter/24/70000166/_api/Web/GetFileByServerRelativeUrl('/matter/24/70000166/Documents/70000166/WWFT/PPP-verklaring%20(NL)%20(2020).docx')/CheckedOutByUser"}},"ListItemAllFields":{"__deferred":{"uri":"http://dms.pelsrijcken.nl/matter/24/70000166/_api/Web/GetFileByServerRelativeUrl('/matter/24/70000166/Documents/70000166/WWFT/PPP-verklaring%20(NL)%20(2020).docx')/ListItemAllFields"}},"LockedByUser":{"__deferred":{"uri":"http://dms.pelsrijcken.nl/matter/24/70000166/_api/Web/GetFileByServerRelativeUrl('/matter/24/70000166/Documents/70000166/WWFT/PPP-verklaring%20(NL)%20(2020).docx')/LockedByUser"}},"ModifiedBy":{"__deferred":{"uri":"http://dms.pelsrijcken.nl/matter/24/70000166/_api/Web/GetFileByServerRelativeUrl('/matter/24/70000166/Documents/70000166/WWFT/PPP-verklaring%20(NL)%20(2020).docx')/ModifiedBy"}},"Versions":{"__deferred":{"uri":"http://dms.pelsrijcken.nl/matter/24/70000166/_api/Web/GetFileByServerRelativeUrl('/matter/24/70000166/Documents/70000166/WWFT/PPP-verklaring%20(NL)%20(2020).docx')/Versions"}},"CheckInComment":"","CheckOutType":2,"ContentTag":"{CC83774E-8B2F-49B6-A3ED-0194A629BE2D},3,16","CustomizedPageStatus":0,"ETag":"\"{CC83774E-8B2F-49B6-A3ED-0194A629BE2D},3\"","Exists":true,"Length":"37775","Level":2,"MajorVersion":0,"MinorVersion":2,"Name":"PPP-verklaring (NL) (2020).docx","ServerRelativeUrl":"/matter/24/70000166/Documents/70000166/WWFT/PPP-verklaring (NL) (2020).docx","TimeCreated":"2020-03-31T11:39:29Z","TimeLastModified":"2020-03-31T11:39:32Z","Title":"","UIVersion":2,"UIVersionLabel":"0.2"}]}}'; // convert into php array $arr = json_decode($json, true); $values = array_column($arr['d']['results'], 'vm'); print_r($values);