0

I built a query to expose as an API which then gets picked up in a power automate flow and up to now this has been running fine.

Yesterday I updated symbols has I had to expose another table as API, we’ve since upgraded to version 24.5.

Today I got this response:
{
“status”: 400,
“message”: “ErrorCode: Application_InvalidOptionEnumValue ‘Recurring_x0020_Invoice’ is not an option. The existing options are: Quote,Order,Invoice,Credit Memo,Blanket Order,Return Order,Recurring Invoice CorrelationId: 8d4596be-42c4-45a8-b8a0-32ae89a10a0a.\r\nclientRequestId: 2819206e-a71e-4a47-aebf-54ec10482410”,
“error”: {
“message”: “ErrorCode: Application_InvalidOptionEnumValue ‘Recurring_x0020_Invoice’ is not an option. The existing options are: Quote,Order,Invoice,Credit Memo,Blanket Order,Return Order,Recurring Invoice CorrelationId: 8d4596be-42c4-45a8-b8a0-32ae89a10a0a.”
},
“source”: “api.businesscentral.dynamics.com”,
“errors”: []
}

and the reason appears to be how the data is coming out of the query has changed, see attached, the encoding x0020 obviously isn’t a valid document type so the flow throws a wobbler

I can attempt to rebuild the query from scratch, but I didn’t touch it…

The raw data inside BC hasn’t changed so it has everything to do with how the SOD is dealing with it

hougaard Answered question October 31, 2024