Ticket_tags - 'OLE DB or ODBC error: [DataSource.Error] OData: Invalid JSON. A comma character ',' was expected in scope 'Array'. Every two elements in an array and properties of an object must be separated by commas.. '

Questions
, , ,
1

I’m using the below M code in Power Query to download the list of Tickets from the ticket_tags table where [tag] = “Merged Tickets”:

let
  Source = OData.Feed("https://bridge-online.cloud/acme-freshdesk/odata4", null, [Implementation="2.0", ODataVersion=4, OmitValues=ODataOmitValues.Nulls, Headers=[Referer = "FreshDesk-Tickets-Incremental" ], Timeout=#duration(0,4,0,0)]),
    #"Filtered Rows" = Table.SelectRows(Source, each ([Name] = "Freshdesk.Freshdesk.ticket_tags@fdk")),
    #"Expanded Data" = Table.ExpandTableColumn(#"Filtered Rows", "Data", {"tag", "id"}, {"tag", "id"}),
    #"Removed Other Columns" = Table.SelectColumns(#"Expanded Data",{"tag", "id"}),
    #"Filtered Rows2" = Table.SelectRows(#"Removed Other Columns", each ([tag] = "Merged Tickets"))
in
    #"Filtered Rows2"

Data starts loading, but after a few minutes unfortunately I’m getting the following error:

Failed to save modifications to the server.
Error returned: 'OLE DB or ODBC error:
[DataSource.Error] OData: Invalid JSON.
A comma character ‘,’ was expected in scope ‘Array’.
Every two elements in an array and properties of an object must be separated by commas.

Can you please assist?

2

Is it possible to add a (anonymized) screenshot of the request details in Invantive Bridge Online Monitoring as described in More insight with new Bridge Online Monitoring?

Please leave at least the following data visible:

  • the title bar with the request ID,
  • the status code, network size and times in the left column,
  • the error code and error message at the very bottom of the left column,
  • the entire right column.