Power Platform Community Forum Thread Details

Business Central Connector "Get Record"

Hi,

I have a PowerAutomate with a trigger of "When a record is created" (in salesInvoices table) in Business Central and then, I want to get the details of this record. So, the second step is "Get record" from the salesInvoices table with Row id from the previous step.

When I test this PowerAutomate, "Get record" step gave me the below error:

{

"status": 400,

"message": "ErrorCode: Internal_ServerError You do not have the following permissions on TableData API Webhook Notification: Insert.\r\n\r\nTo view details about your permissions, see the Effective Permissions page. To report a problem, refer to the following server session ID: '24223'. CorrelationId: 41626feb-809d-41e2-aaa0-e81ecc3b9ff2.\r\nclientRequestId: 281c87f4-d1e3-4c9f-9dc7-e267f6af2722",

"error": {

"source": "api.businesscentral.dynamics.com",

"errors": []

}

It looks like I don't have permission to "Insert" data to this table (salesInvoices).

However, I have another PowerAutomate that is manually triggerred to "Get record" from the same table (salesInvoices) in the same Business Central environment. Here, I provided the "Row id" in the PowerAutomate. This runs successfully and data values from this record is retrieved.

Given the above, I suspect that something is not quite right with the connector.

Any idea?

dchan

Hi,

Some clarification:

"Get Record" is successful in retrieving a "Posted Sales Invoice".

"Get Record" failed in retrieving a "Sales Invoice".

I am assuming the table name for both "Sales Invoice" and "Posted Sales Invoice" are salesInvoices.

The rationale is that when I use "When a record is created" trigger and set the table to salesInvoices, when a new "Sales Invoice" is created, the trigger fires.

Does that mean "Get Record" cannot retrieve "Sales Invoice"? or the table for "Sales Invoice" is somehow hidden from the table dropdown list in "Get Record" step?

For the error reported in the previous post, I think it is related to the account I use. When I am in BC under that account trying to post a Sales Invoice to become a Posted Sales Invoice, I got that same error.

dchan1

Quick Links