Hello,
I am trying to use Power Automate to fill in the vendor bank details. I know this is done on the bank card and there is a link between the bank details and the vendor through the vendor number. The table itself is not available in the standard API, so I have created an API page myself. If I query the API page (though the "Find Records" connector in Power Automate for example), I see the Vendor No and Code fields that need to not be blank, along with 5 other fields of data that the vendors supply.
When I try to use the "Create Record" however, I only get the five other fields and not the Vendor No and Code. Running the flow will make it fail as Vendor No and Code cannot be blank.
Any ideas how I can fix this?
Thanks!