Forum Discussion

Nav's avatar
Nav
Ace
7 years ago

Lithium bulk data API - To add Json header

Hi, I have tried to add JSON header in the CURL request to get the response in JSON format instead CSV. It is not accepting. curl_setopt($ch, CURLOPT_HTTPHEADER, array("client-id: *****************...
TariqHussain's avatar
TariqHussain
Boss

Nav - What is the response are you getting from server? 

Nav's avatar
Nav
Ace
7 years ago

Hi TariqHussain,

I am getting response in CSV format.

Thanks.

  • TariqHussain's avatar
    TariqHussain
    Boss
    7 years ago

    Nav- Below is the example code which is working and giving response in JSON format.

     

    <?php

$curl = curl_init();

curl_setopt_array($curl, array(
  CURLOPT_URL => "https://api.lithium.com/lsi-data/v1/data/export/community/******/?fromDate=20180101&toDate=201801020100&fields=conversation.uid,conversation.title,action.weight,message.type,message.is_topic",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => array(
    "accept: application/json",
    "authorization: Basic ***************",
    "client-id: ****************"
  ),
));

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}
    • Nav's avatar
      Nav
      Ace
      7 years ago

      Hi TariqHussain,

      Thanks. I tried in different way and managed to pull what I am expected.

      curl_setopt($ch, CURLOPT_HTTPHEADER, array("client-id: ********", "Accept: application/json"));
      $result = curl_exec($ch);
$res = json_decode($result, true);
      return $res;

      :)

       

      • TariqHussain's avatar
        TariqHussain
        Boss
        7 years ago

        Nav - Glad to know, it worked.