LordHaywoodOriginal post
Rank 1: Thread
I'm trying to import database data via CSV via API, however getting "The current user is not authorized to perform the requested action." after the API key has "migrations.write" access. (This was erroring/checked prior to adding the permission to the key)
e.g.
await client.call("POST", new URL("https://appwrite.domain.com/v1/migrations/csv"), {
"content-type": "application/json"
}, {
bucketId: "dbBootData",
fileId: "trees.csv",
resourceId: prod:trees,
internalFile: true
})
Summary
To import CSV via API, ensure the user has privileged role like USER_ROLE_OWNER, USER_ROLE_DEVELOPER, or USER_ROLE_ADMIN. To get a node-sdk with this role, turn off "internalFile" in the code located at the specified GitHub link.