Anyone here have made API calls to a D1 instance to query the db? The error im receiving: `The req

Anyone here have made API calls to a D1 instance to query the db?

The error im receiving:

The request is malformed: failed to decode id

The request is malformed: failed to decode id

The request is malformed: failed to decode id

The request is malformed: failed to decode id

url:

https://api.cloudflare.com/client/v4/accounts/{account_id}/d1/database/{db_id}/query

https://api.cloudflare.com/client/v4/accounts/{account_id}/d1/database/{db_id}/query

https://api.cloudflare.com/client/v4/accounts/{account_id}/d1/database/{db_id}/query

https://api.cloudflare.com/client/v4/accounts/{account_id}/d1/database/{db_id}/query

const insertStatement = `INSERT INTO table (column1, column2) VALUES ('value1', 'value2');`;

const insertStatement = `INSERT INTO table (column1, column2) VALUES ('value1', 'value2');`;

const insertStatement = `INSERT INTO table (column1, column2) VALUES ('value1', 'value2');`;

const insertStatement = `INSERT INTO table (column1, column2) VALUES ('value1', 'value2');`;

const options = {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json',
      Authorization: 'Bearer {api_token}'
    },
    body: `{"sql": ${insertStatement}`
  }

const options = {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json',
      Authorization: 'Bearer {api_token}'
    },
    body: `{"sql": ${insertStatement}`
  }

const options = {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json',
      Authorization: 'Bearer {api_token}'
    },
    body: `{"sql": ${insertStatement}`
  }

const options = {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json',
      Authorization: 'Bearer {api_token}'
    },
    body: `{"sql": ${insertStatement}`
  }

I'm not exactly where to go from here unfortunately. Any assistance would be greatly appreciated.

kian•2/28/24, 3:46 PM

Are you sure db_iddb_id is right?

kian•2/28/24, 3:46 PM

You're also missing a closing bracket in your bodybody from the looks of it

MongyOP•2/28/24, 3:46 PM

copied straight from the d1 instance

kian•2/28/24, 3:47 PM

the AuthorizationAuthorization header also doesn't seem to be actually interpolating the api_tokenapi_token variable

MongyOP•2/28/24, 3:48 PM

ive tried using X-Auth-KeyX-Auth-Key but i get an error that it doesn't exist in the request

Kkian You're also missing a closing bracket in your `body` from the looks of it

MongyOP•2/28/24, 3:48 PM

that's embarresing. Added the bracket but the error still persists

kian•2/28/24, 3:48 PM

It's probably an issue with the URL path or the API token

kian•2/28/24, 3:49 PM

What did you put in for account_idaccount_id and db_iddb_id? They're not sensitive.

MongyOP•2/28/24, 3:49 PM

Account id: 4f6d1970bc967b2c2a90b643bbb5ac944f6d1970bc967b2c2a90b643bbb5ac94
db id: 0e35121-f3cc-4e24-b5c1-4d758860a69d0e35121-f3cc-4e24-b5c1-4d758860a69d

MongyOP•2/28/24, 3:50 PM

permissions for api token has read and write for D1

kian•2/28/24, 3:50 PM

Does the URL look correct if you console.logconsole.log it?

MongyOP•2/28/24, 3:52 PM

looks good

https://api.cloudflare.com/client/v4/accounts/4f6d1970bc967b2c2a90b643bbb5ac94/d1/database/0e35121-f3cc-4e24-b5c1-4d758860a69d/query

https://api.cloudflare.com/client/v4/accounts/4f6d1970bc967b2c2a90b643bbb5ac94/d1/database/0e35121-f3cc-4e24-b5c1-4d758860a69d/query

kian•2/28/24, 3:53 PM

and if you log

options

options

then you see Authorization: Bearer ...Authorization: Bearer ...?

MongyOP•2/28/24, 3:53 PM

the account id came from the pages/workers overview dashboard

kian•2/28/24, 3:53 PM

It all seems fine, the error is pretty vague.

MongyOP•2/28/24, 3:53 PM

yes i see the bearer when logging

Kkian It all seems fine, the error is pretty vague.

MongyOP•2/28/24, 3:54 PM

Yeah that's why I've come here to see if anyone has experienced something similar. It is offly vague

Original message was deleted

MongyOP•2/28/24, 4:11 PM

the uuid matches to what im putting in the url

Original message was deleted

MongyOP•2/28/24, 4:19 PM

Still receiving the same message

MongyOP•2/28/24, 4:22 PM

const D1URL = 'https://api.cloudflare.com/client/v4/accounts/4f6d1970bc967b2c2a90b643bbb5ac94/d1/database/0e35121-f3cc-4e24-b5c1-4d758860a69d/query';

const insertStatement = `INSERT INTO table (c1, c2, c3) VALUES (v1, v2, v3)`;

const options = {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json',
      Authorization: 'Bearer GAQjclxUayPOaHhn5Nx1CGdyN2Pt08COkmFTFBjm'
    },
    body: JSON.stringify({
      sql: insertStatement
    })
  }

fetch(D1URL, options)
    .then( res => res.json())
    .then( data => console.log(data))

const D1URL = 'https://api.cloudflare.com/client/v4/accounts/4f6d1970bc967b2c2a90b643bbb5ac94/d1/database/0e35121-f3cc-4e24-b5c1-4d758860a69d/query';

const insertStatement = `INSERT INTO table (c1, c2, c3) VALUES (v1, v2, v3)`;

const options = {
    method: 'POST',
    headers: {
      'Content-Type': 'application/json',
      Authorization: 'Bearer GAQjclxUayPOaHhn5Nx1CGdyN2Pt08COkmFTFBjm'
    },
    body: JSON.stringify({
      sql: insertStatement
    })
  }

fetch(D1URL, options)
    .then( res => res.json())
    .then( data => console.log(data))

MongyOP•2/28/24, 4:23 PM

just simplified the insert statement

MongyOP•2/28/24, 4:24 PM

already did when i realized lol

MongyOP•2/28/24, 4:25 PM

but the api token has both read and write permissions for d1 instance

MongyOP•2/28/24, 4:25 PM

they are actual strings

MongyOP•2/28/24, 4:25 PM

i just renamed them

MongyOP•2/28/24, 4:26 PM

i ran the same sql directly through the d1 dashboard

MongyOP•2/28/24, 4:26 PM

and populated just fine

MongyOP•2/28/24, 4:26 PM

same one im using in this script, not the one i posted here

MongyOP•2/28/24, 4:27 PM

its an id problem but its not specifying what id its trying to decode

kian•2/28/24, 4:30 PM

Your DB ID is wrong

kian•2/28/24, 4:30 PM

It isn't formatted properly

kian•2/28/24, 4:30 PM

Yeah

kian•2/28/24, 4:30 PM

It's 7-4-4-4-12 when it should be 8-4-4-4-12

kian•2/28/24, 4:31 PM

Probably the first letter got cut off when copying

MongyOP•2/28/24, 4:36 PM

That did the job

MongyOP•2/28/24, 4:37 PM

I appreciate it

kian•2/28/24, 4:38 PM

@Max (@rozenmd) I'm not sure if the error is thrown by the API gateway before it gets to D1's REST API, but it'd be cool if the "failed to decode id" error could be more detailed even if it just calls out which ID it's upset with - d1-database

Max (@rozenmd)•2/28/24, 4:39 PM

ah yeah nah that's the rust uuid parser

Max (@rozenmd)•2/28/24, 4:39 PM

we'll be fixing this

Sébastien Morel•2/28/24, 7:48 PM

hello here I know we are still in beta with D1 but I just want to see if that makes sense. Without D1 I have 40ms latency on my worker, as soon as I do a query (simple select on an ID that has an index) it goes to 400ms... like 10x... am I doing something wrong ?

Aaryan•2/28/24, 8:03 PM

Guys my d1 f19f4e90-2514-4f2f-9d09-13ece5212673f19f4e90-2514-4f2f-9d09-13ece5212673 is down. I really need it back for my presentation at uni tomorrow. Is there a time frame? or should I make another?

Original message was deleted

Sébastien Morel•2/28/24, 8:04 PM

that's something I don't know how to check, where is the DB ?

Sébastien Morel•2/28/24, 8:05 PM

here is an example of meta @nora

"result": {
"success": true,
"meta": {
"served_by": "v3-prod",
"duration": 0.1743,
"changes": 0,
"last_row_id": 0,
"changed_db": false,
"size_after": 25100288,
"rows_read": 1804,
"rows_written": 0
},
"results": [
{
"COUNT(*)": 1804
}
]

"result": {
"success": true,
"meta": {
"served_by": "v3-prod",
"duration": 0.1743,
"changes": 0,
"last_row_id": 0,
"changed_db": false,
"size_after": 25100288,
"rows_read": 1804,
"rows_written": 0
},
"results": [
{
"COUNT(*)": 1804
}
]

Sébastien Morel•2/28/24, 8:05 PM

383ms to get it

Sébastien Morel•2/28/24, 8:09 PM

wrangler d1 info

Sébastien Morel•2/28/24, 8:09 PM

got it so same region with my worker checking the header CF-Placement

Sébastien Morel•2/28/24, 8:11 PM

also for SELECT query is it not supposed to be distributed?

AAaryan Guys my d1 `f19f4e90-2514-4f2f-9d09-13ece5212673` is down. I really need it back...

Aaryan•2/28/24, 8:22 PM

seems to be back

Sébastien Morel•2/28/24, 8:29 PM

I am debugging a bit more and it seems to be the _QUEUE?.send(payload)_QUEUE?.send(payload) done right after the query that changes the game based on user location. Do queues have locations too?

wesbos•2/28/24, 8:31 PM

Hello - trying upload a DB. I followed the docs of dumping it sqlite3 mydb.sqlite .dump > db.sqlsqlite3 mydb.sqlite .dump > db.sql and then import with wrangler d1 execute podcast-stats-prod --file=db.sqlwrangler d1 execute podcast-stats-prod --file=db.sql but I get not authorized [code: 7500]not authorized [code: 7500] error.

Seems to be related to this? https://github.com/cloudflare/workers-sdk/issues/3892 Any ideas how to work around it? Its a 10,000 line long file so Im notsure where to look

GitHub

🐛 BUG: d1 execution with comment including semicolon causes SQL cod...

Which Cloudflare product(s) does this pertain to? D1 What version(s) of the tool(s) are you using? 3.6.0 What version of Node are you using? 20.5.1 What operating system are you using? Mac Describe...

Anyone here have made API calls to a D1 instance to query the db? The error im receiving: `The req

Similar Threads

Similar Threads

Similar Threads