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: *****************...
Nav's avatar
Nav
Ace

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.