Pass Array to CURL - Read CSV file

Question

My CSV has a single column with 40000 phone numbers

The following code read the CSV column and is fast

$dataArray = csvstring_to_array( file_get_contents('test.csv'));

My CURL code looks like this

$ch = curl_init();

     $data = http_build_query($dataArray);

    curl_setopt($ch, CURLOPT_POSTFIELDS, $dataArray);
    curl_setopt($ch, CURLOPT_URL, "https://api.theblacklist.click/standard/api/v1/bulkLookup/key/[APIKEY]/response/json");
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($ch, CURLOPT_POST, 1);

    $output = curl_exec($ch);

The JSON parameters expected by the API look like the following. I am stuck about how to pass the "phones":[ and then pass the CSV Data array as a parameter to the curl/API?

curl -XGET ''
  -H 'Content-Type: application/json' 
  -d'
{
  "phones":[
  "15555558353",
  "15555555555",
  "15555552740",
  "15555552741",
  "15555552738"
  ]
}'

Does this answer your question? How do I use arrays in cURL POST requests — Justinas
– Justinas, Commented Jan 22, 2020 at 18:50
@Justinas I tried $dataArray = ["phones" => csvstring_to_array( file_get_contents('test.csv'))]; it returns blank Array — TSCAmerica.com
– TSCAmerica.com, Commented Jan 22, 2020 at 18:55

Anggara · Accepted Answer · 2020-01-22 19:02:32Z

1

It seems the API server expect JSON-formatted data to be passed as POST body

$dataArray = csvstring_to_array(file_get_contents('test.csv'));
$jsonString = json_encode(['phones' => array_values($dataArray)]);

curl_setopt($ch, CURLOPT_POSTFIELDS, $jsonString);

answered Jan 22, 2020 at 19:02

Anggara

6464 silver badges9 bronze badges

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

10 Comments

TSCAmerica.com Over a year ago

1. When I use this print_r($dataArray); it prints the data 2. when I print this $jsonString = json_encode(['phones' => array_values($dataArray)]); echo "JSON>>>>".$jsonString; It is Blank?

Anggara Over a year ago

What version of PHP are you using? Can you use print_r($jsonString); instead?

TSCAmerica.com Over a year ago

php 7, echo print_r($jsonString); returns 1

Anggara Over a year ago

You don't need echo before print_r.What is the content of $dataArray? Is it like ['phone1', 'phone2', 'phone3'] ?

Anggara Over a year ago

Just blank? Can you print something after it? It might caused by PHP error. You may want to enable error reporting: error_reporting(E_ALL); ini_set('display_errors',1); at the beginning of script

|

Collectives™ on Stack Overflow

Pass Array to CURL - Read CSV file

1 Answer 1

10 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related