Hi Community, I am a Swiss based shopify user with an API issue that I really need some help on. I posted some weeks back yet didnt get a solution and not really sure what else to do except for post again and beg for assistance
I use a third party API to transfer data to my accounting system. When a sale is made in shopify it transfers the data through a third party named Bedaya Connect and then into Bexio accounting system. The issue is that Shopify data is adding many many characters during the transfer of teh address to bedaya connect meaning that when it gets to my accounting system it has a melt down and shows the sale as unpaid / pending. (see screen shot of example)
Could anyone please look into fixing this issue please? Its been unsolved until now and my accounting is somewhat messed up
Thanks for your support
Victoria
Support Ticket for internal ref to API team: 43250235
Is the screenshot you’ve shared here from Bedaya Connect or Bexio? It’s possible as data is being transferred from one platform to another, that something in the chain is causing the addresses to have unexpected formatting.
One thing you could try would be to test how Shopify is exporting the order data to your third-party service, by running the same query manually and checking what is being returned.
From your screenshot it looks like the service you’re using is querying the Admin APIs customer endpoint, using the ID of the customer to return the name, address, and other details of the customer. You can use Shopify’s GraphiQL app to make the same query and compared what is being returned with the source of the screenshot you’ve shared.
Once the GraphiQL app is installed you can run this query and you should get the customers address returned:
query {
customer(id: "gid://shopify/Customer/6990235304182") {
email
firstName
lastName
defaultAddress {
address1
address2
city
province
zip
country
}
}
}
If you still see all the instances of 29 returned for address1 then it does look like there is an issue on Shopify’s side and we can look into this deeper. However if the correct address is being returned, then the issue is likely occurring further down the chain than this query, so it could be worth seeing how the data is being received from Shopify after this query is being made.
Hi Liam, thank you for this. I tried to follow your instructions but seems i am technically challenged. See screenshot of what came back when i followed your instructions (I treid to upload screenshot but not supported file). Can you support to provide step by step instructions please? Thanks, Victoria