How to Insert data to CloudTables database using cURL/HTTP in PHP? Error: API Key is required

Question

I'm inserting a row to the CloudTables database using cURL request. following is the sample cURL request available on their [documentations][1]:

curl \
    -X POST \
    -d key=:apiKey \
    https://sub-domain.cloudtables.io/api/1/dataset/:id

Where

:apiKey is the API key to use for access (see below)
:id is the dataset id (a UUID),

And below is my PHP Code:

    $post = array(
        'clientId' => $user_id,
        'clientName' => $user_email,
        'dp-01' => $user_id,
        'dp-02' => $user_type,
        'dp-03' => $fullname,
        'dp-04' => $address,
    );

    $ch = curl_init('https://sub-domain.cloudtables.io/api/1/dataset/my-dataset-id');
    curl_setopt($ch, CURLOPT_HTTPHEADER, array('key: my-api-key'));
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $post);
    $response = curl_exec($ch);
    curl_close($ch);

But every time response says:

[
  {
     "msg":"API key is required",
     "name":"key"
  }
]

Why!!! What is the right way to send API key?

I also tried sending API key in $post array and in URL, but getting same response. [1]: https://cloudtables.com/docs/cloud/api/rest/post-dataset

curl -d is not for setting values in the header, it's for data (curl.se/docs/manpage.html#-d). Try putting key and apiKey into the $post data. — Alan
– Alan, Commented Nov 2, 2021 at 18:25
@Alan already tried putting "key" => "APIKey" into $post but still getting same error! — Sourav Dutt
– Sourav Dutt, Commented Nov 2, 2021 at 18:48
Passing an array for CURLOPT_POSTFIELDS, will make it send a multipart/form-data request - maybe the API doesn't like those? Try curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($post));, and see if that changes anything. — C3roe
– C3roe, Commented Nov 3, 2021 at 9:35
Thanks @CBroe; It's working now! I request you to plz post this as answer so I can mark it as solution. so it can help for others. ` $post = array( 'key' => 'my-api-key', 'clientId' => $user_id, 'clientName' => $user_email, 'dp-01' => $user_id, 'dp-02' => $user_type, 'dp-03' => $fullname, ); $ch = curl_init('sub-domain.cloudtables.io/api/1/dataset/my-dataset-id'); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($post)); $response = curl_exec($ch); curl_close($ch); ` — Sourav Dutt
– Sourav Dutt, Commented Nov 5, 2021 at 5:47

C3roe · Accepted Answer · 2021-11-05 07:19:32Z

3

Passing an array for CURLOPT_POSTFIELDS, will make it send a multipart/form-data request - whereas the API apparently expects application/x-www-form-urlencoded.

Use curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($post)); instead

answered Nov 5, 2021 at 7:19

C3roe

97.8k15 gold badges100 silver badges172 bronze badges

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

Collectives™ on Stack Overflow

How to Insert data to CloudTables database using cURL/HTTP in PHP? Error: API Key is required

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related