
Announcements
Hello Community,
I have a SQL table that PA successfully returns rows and I want to transfer each row to a custom table (batchlines) in Dynamics BC using "Create Record (V3)". I can successfully connect to the BC table and manually enter records, one record at a time from PA. Unfortunately, when I attempt to programmatically transfer this data with an "Apply to Each" loop, PA throws the error: "BadRequest A body must be provided to the request.". When I check the raw inputs, a body is included. The correlation ID in the error message below may hint at a parent/child table relationship but it does not generate errors when manually entering records to this table. Is there a better way to transfer data from SQL to BC using PA?
Thanks in advance
---Wayne
The problem has been resolved. Although not many details were provided, the vendor who created these custom tables made an adjustment which resolved the flow issues. No updates to the flow were made to resolve the issue.