Invalid/restricted characters in transaction descriptions causing API call to fail

[LiamSmith]

Hi Team,

We have a number of ledgers (5 out of 400) where the client is using either import functions in MYOB or other addon's to push data into MYOB.

The issue seems to be that you can import/create via add on a description on a transaction which contains invalid/restricted characters without any issues but that the JournalTransaction API endpoint will then choke and error on when trying to read them back.

Can you please give me a list of characters that this occurs with so at a minimum I can go back into the GL reports and find/replace those characters so the API will work correctly?

Ideally; fix it so the API doesn't choke!

Cheers,

Liam

1. {title: "An unhandled exception occurred", status: 500,…}
   1. detail: "Encountered a communication error (https://ar1.api.myob.com/accountright/<REDACT>/GeneralLedger/JournalTransaction/?$top=400&$skip=0&$filter=DateOccurred ge datetime'2019-07-01' and DateOccurred le datetime'2020-06-30')"
   2. instance: "urn:<REDACT>:internalservererror:<REDACT>"
   3. status: 500
   4. title: "An unhandled exception occurred"

[Mike_James]

Hi @LiamSmith , I've seen reference to this error where the file is v2019.4 and on the desktop. If that's the case here, please see https://apisupport.myob.com/hc/en-us/articles/360001359796-AR-2019-4-Local-API-500-InternalServer-Is.... 

The only solutions offerred are to upgrade to 2020.1 or put the file in the cloud. 

[LiamSmith]

Hi Mike,

Can confirm these are cloud files and pretty sure most are 2019.4.

The issue is we start seeing data from the API but then it stops mid way through when it hits 'bad' data inside the MYOB file.

We have an integration ourselves + also through another vendor and both have this exact same issue on the exact same files.

The only thing we've had back from the vendor was that they raised it with MYOB support, it's a known issue and to manually find the characters and remove.

The issue is they don't specify what characters or what's the easiest way to find them. 

Very frustrating!!