You're also missing a closing bracket in your `body` from the looks of it
You're also missing a closing bracket in your
body from the looks of itAuthorization header also doesn't seem to be actually interpolating the api_token variableX-Auth-Key but i get an error that it doesn't exist in the requestaccount_id and db_id? They're not sensitive.4f6d1970bc967b2c2a90b643bbb5ac940e35121-f3cc-4e24-b5c1-4d758860a69dconsole.log it?https://api.cloudflare.com/client/v4/accounts/4f6d1970bc967b2c2a90b643bbb5ac94/d1/database/0e35121-f3cc-4e24-b5c1-4d758860a69d/queryoptions then you see Authorization: Bearer ...?f19f4e90-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?
_QUEUE?.send(payload) done right after the query that changes the game based on user location. Do queues have locations too?sqlite3 mydb.sqlite .dump > db.sql and then import with wrangler d1 execute podcast-stats-prod --file=db.sql but I get not authorized [code: 7500] error. not authorized gets thrown by the runtime when an sql command we haven't allow-listed gets used - look for things like pragma statementsPRAGMA foreign_keys=OFF; is the first lineconst 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))"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
}
]