Error: Internal Error. Looks like Something Went Wrong on Our End. Request ID: XXXXXXXX-XXXX-XXXX-XX

[AmnaShafiq]

I am trying to synchronize and pull products from my shopify store to business central using the shopify connector. I have the setup configured and the connection is successful but when I synchronize the products or customers I get the following Error. I need a little help to figure out what exactly is causing this error. I am writing here as the microsoft trouble shooting led me here. (Screenshot attached)

[A6-dev]

Hi, I have the same error.

Did you solve this?

[CedricVl]

Hi

We have had contact with someone from microsoft. The provided us with the following solution.

Thank you for reaching out and providing all details,

We are aware of that issue:

Symptom:

Getting error like this: [{"message":"Internal error. Looks like something went wrong on our end.\nRequest ID: 07855295-9363-4201-a8f2-b95a5a685013 (include this in support requests).","extensions":{"code":"INTERNAL_SERVER_ERROR","requestId":"07855295-9363-4201-a8f2-b95a5a685013"}}]

Usually happens when import products, customers or orders (mainly all business critical tasks).

Who:

For customers with version 23.x and using Shopify Admin API 2023-04.

Starting to use Shopify connector (existing customers are usually not affected, see below)

Mitigation.

Navigate to Shopify Shop card, choose Actions -> Reset Sync -> Customers. If date is empty, enter some date, like 2004-01-01 (I don’t think anyone will have records earlier). Repeat for Products and Orders.

Reason:

Looks like (we are working with Shopify on confirmation) that the way empty parameters are processed was changed. It means for cases when we query Customer, Orders or Products from “beginning of time” the Shopify cannot handle such queries anymore.

You can see sample query in Shopify log: {"query":"{customers(first:200, query: \"updated_at:>''\"){pageInfo{hasNextPage} edges{cursor node{id updatedAt}}}}"}. Notice that there is no value after updated_at.

This worked in the past. Doesn’t work anymore.