topic Re: Issue with Intacct Integration updates in Workato Pros Discussion Board

Issue with Intacct Integration updates

reggie-madrigal — Wed, 27 Oct 2021 23:22:01 GMT

If there is anyone here who does integrations with Sage Intacct, I am trying to update a record, and I keep getting an error BL01001973, Document ID does not exist. In Sage Intacct, the document Id does exist, but the error description shows that I am adding the encoding ' which is a single quote.

I have tried using the gsub("'","") to strip them out, as well and using the .encode(UTF-8), The input looks correct on the surface though.

Does anyone have any ideas as to why this is occurring, and has a resolution?

Re: Issue with Intacct Integration updates

hire-jorge — Thu, 28 Oct 2021 00:52:32 GMT

I have not to work with Sage Intacct. That said, when I receive errors that are difficult to understand in Workato UI. I attempt to create the call outside UI editor in a http request tool like Postman. Postman most of the time reveals more information about the error. Did you attempt to update the record outside of Workato? Did you receive the same error?

Look at the Sage Intacct HTTP documentation for the record you are trying to update, to ensure the request is being sent correctly.

Hope this helps you resolve or find the root cause of the issue.

Outcome: Fix to http request or a workato ticket to address connector issue.

Re: Issue with Intacct Integration updates

reggie-madrigal — Thu, 28 Oct 2021 00:53:43 GMT

Thank you Jorge. I found the issue. The record is locked and I needed location override.

Re: Issue with Intacct Integration updates

hire-jorge — Thu, 28 Oct 2021 00:54:02 GMT

there you go