Automating AppSheet “Add” via REST API from Odoo polling—403 Forbidden even though Integration UI is

[fahad_khan]

Hi everyone,

I’m building an integration that will poll Odoo for new Material Transfer Requests and then automatically create corresponding Requests (with line items) in our AppSheet app (“Request Manager”). My plan is:

1. Poll Odoo every few minutes for new requests that meet our criteria.
2. Map the Odoo JSON fields to our AppSheet columns (Expense_Type, Requested_By, Due_Date, line items, etc.).
3. POST to the AppSheet REST API /tables/Requests/Action to add a Draft-status Request, then /tables/LineItems/Action to add its items.

What I’ve tried

• In AppSheet Editor ▶ Settings ► Integrations, I’ve toggled IN: from cloud services to your app ON and generated/enabled two Access Keys.
• Copied the App ID and Access Key exactly into my Apps Script.
• Switched to the HTTP-Basic style header per Google’s docs:

headers: {
  'Authorization': `Token token="${ACCESS_KEY}"`,
  'Accept':        'application/json'
}

• Verified with cURL directly against the AppSheet endpoint:

curl -v -X POST \
  https://www.appsheet.com/api/v2/apps/<AppID>/tables/Requests/Action \
  -H 'Authorization: Token token="V2-abc123...xyz"' \
  -H 'Accept: application/json' \
  -H 'Content-Type: application/json' \
  -d '{
    "Action":"Add",
    "Properties":{"Locale":"en-US","Timezone":"Asia/Riyadh"},
    "Rows":[{"Status":"Draft"}]
  }'

The error I’m seeing

{
  "title":"Forbidden",
  "status":403,
  "detail":"The ApplicationAccessKey in the HTTP header did not match any of the valid ApplicationAccessKeys for the called application."
}

Screenshot of my Integrations settings

My questions

1. Why am I still getting a 403 when the Integration UI clearly shows the API as enabled?
2. Is there any workaround—without switching to a different AppSheet plan—to POST new rows from an external script?
3. Could I leverage an in-app webhook or Bot on our current plan to accomplish the same end-to-end flow?

Thanks in advance.