I am working with a custom flow that pulls data from the “Balances” table on a project record in Acumatica and then the import looks for a specific account group value and posts that number into Salesforce.
On the export I used Launch>Expand to include the "Balances."
When I set the export to retrieve a single project everything works as expected. When I switch it to either all or delta, I get this error.
Does anyone know the best way to extract this information?
I was thinking of trying it a different way and using an export from Salesforce to get project ID's and then using a lookup to Acumatica and then returning the values to Salesforce, but I am not sure how to set the results mapping to retrieve a specific value from the balances table. This is how it worked on the import mapping that I got to work with a single project export:
I just cannot seem to figure out the correct way to convert it for the “results mapping” from the lookup.
Any thoughts on which approach would work better or how to get around the error?
Thank you in advance.