Zoho Inventory - Sales Order Export - Addresses Missing

  • 259Views
  • Last Post 01 February 2019
  • Topic Is Solved
0
votes
Phil Garner posted this 30 January 2019

Hi,

I've been running some queries to extract Sales Order data from my Zoho Inventory Org.  The queries run normally and return the data I'd expect from my test Sales Orders.  But in all cases the Shipping Address is not present in the retuned data.

Is this a limitation of skyvia?

Kind regards

Phil

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 30 January 2019

Hi Phil!

We have reproduced this behaviour. We will investigate it more clearly and contact you as soon as any results are available.

 

Best regards,

Mariia

0
votes
Mariia Zaharova posted this 31 January 2019

Hi Phil!

We have investigated this behaviour. Zoho Inventory API does not allow to get information from all the fields (such as Shipping Address, Billing Address, etc.) when retrieving all SalesOrders records. In order to get Shipping Address information it is necessary to use filter on the Id field, for example:

SELECT t.*
FROM SalesOrders AS t
WHERE (t.Id = '36917500011229025')

 

Best regards,

Mariia

0
votes
Phil Garner posted this 01 February 2019

Hi Mariia,

Thanks, that makes perfect sense, and I've manged to extract all data from one of my test Sales Orders using your query.

My plan was to make a Skyvia Replication package to send all of my Zoho Sales Orders to SQL Server.  Due to the limitation of the Zoho API I can only replicate the basic data - not including the addresses etc.

Can you suggest how I might achieve a replication of the full data in Skyvia? The replication tool doesn't allow a Source Lookup for the Sales Order ID, so only the basic data is replicated.

Kind regards

Phil

 

 

Close