table \"<>\" does not exist in source: <>"

[ajithv92]

how to use metadata apis for create permissions (select, insert, delete etc) on Hasura. seems like using the template written in doc is not helping me..

all is get always is a BadRequest with 400 with error on body

{
"path": "$.args",
"error": "table "Devices" does not exist in source: ISAXQA",
"code": "not-exists"
}

would like some help on this !!

[ecthiender]

From the screenshot above, it looks like this is a MS SQL Server database. In that case, you'd have to use the SQL Server related metadata APIs (starts with mssql_). For creating select permission it would be mssql_create_select_permission. Full docs here: https://hasura.io/docs/latest/api-reference/metadata-api/permission/#mssql-create-select-permission

[ajithv92]

thank you !! also is there a way to do bulk updates like select, insert update, delete permission in one api request ?

[ecthiender]

Yes! Check out the bulk query type in the metadata API. You can add multiple metadata queries in one bulk query and make one API request.