i need to translate this json into a php array then cycle through the items and put them into there respective columns i have tried using json decode on it own but all i get back is the text array i know the request works fine and gives the following output :

Decoding JSON is not going to magically put things into an associative array. The JSON structure you have there represents an array of objects. You would need to map this to an associative array yourself like this: