Json save data to JSON file from API using PHP (curl)

Question

I have written this code to get data from API URL. All data is written to my file, but I can't find solution to make it look like Json format in file, what I am missing? Everything I tried in file showing like text (Added example below) and what I want. Maybe someone will help me with this :). Thanks!

Source code using php curl to get and save data

<?php
$token = "eyJ";
$ch = curl_init("https://api.xxx.com/api/Catelo/Prod?cat=MPHEFGZ");
$fp = fopen("prod.json", "w");

curl_setopt($ch, CURLOPT_HTTPHEADER, array(
   'Content-Type: application/json',
   'Authorization: Bearer ' . $token
   ));
curl_setopt($ch, CURLOPT_FILE, $fp);
curl_setopt($ch, CURLOPT_HEADER, 0);

curl_exec($ch);
curl_close($ch);
fclose($fp);
?>

I want it to save to file like this:

What I expect (saved format):

"FIFA_Last_World_Cup_final":
{
    "Year": "2018",
    "data":
    {
        "Winner": "France",
        "Score": "4-2",
        "Runner-up": "Croatia"
    }
}

What I get now when data is saved to file:

[{"id":1,"Code":1,"name":"TV","manu":"32","v":"P","v":"P","c":"T","q":"0","p":1.0,"d":1.0,"imagePath":"e0bc7.Jpeg","thumbnailImagePath":"0bc7.Jpeg","fullDsc":"32\"","cury":"E","httpD":"548","packy":1,"ty":"24","eae":"","obligaKit":0,"reerty":0,"proate":0,"pront":70,"quane2":"0","pri":0.0,"lotN":"","p":0.0,"i":70}

@NigelRen Yes, what I want is to save data as json format, not raw. Just I don't find out how to make it pretty.. — zte813
– zte813, Commented Nov 13, 2019 at 16:14

Nigel Ren · Accepted Answer · 2019-11-13 16:15:22Z

4

As you are not processing the response from the API, what you see is just how the response is sent. To format it, you can capture the output (using CURLOPT_RETURNTRANSFER) and then decode the response - re-encoding it with JSON_PRETTY_PRINT.

curl_setopt($ch, CURLOPT_HTTPHEADER, array(
    'Content-Type: application/json',
    'Authorization: Bearer ' . $token
));
curl_setopt($ch, CURLOPT_FILE, $fp);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

// Store the JSON from the API
$response = curl_exec($ch);
curl_close($ch);
fclose($fp);

// Decode it, re-encode with formatting
echo json_encode(json_decode($response), JSON_PRETTY_PRINT);

answered Nov 13, 2019 at 16:15

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

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

5 Comments

zte813 Over a year ago

how can i add this echo json_encode(json_decode($response), JSON_PRETTY_PRINT); code to file (where it must go in my code to save as pretty json data in json file?

Nigel Ren Over a year ago

Have you tried it as in the example code (after the fclose($fp);)

zte813 Over a year ago

yes I tried, but nothing changed. :) Tried to replace rows, but still nothing worked out.. :(

Nigel Ren Over a year ago

What do you get if you echo $response;. Check that is is formed properly.

Muhammad Zohaib Yunis Over a year ago

curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); it allows you to save / directly parse.

Collectives™ on Stack Overflow

Json save data to JSON file from API using PHP (curl)

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related