OData Query: An error has occurred. - Request URL: undefined

  • 1
  • Problem
  • Updated 1 year ago
  • Acknowledged
I am trying to use Zoho CRM data in Skuid. I previously posted about multiple issues accessing Zoho through API but nobody bothered to respond to that one so I've been forced to try another route - Skyvia which gives OData access to all kinds of data resources (and has no problem locking in on the Zoho API - did it in about 2 minutes). 

I can connect to Skuid with Skyvia using OData just fine for fields like "BDay" and "ContactID" ... BUT ... The PROBLEM is when I try to bring in object data from a field with a name like "Last Name" or "First Name" (it is standard for Zoho field names to have 2 words), I get this error from Skuid:

1. There was a problem with an OData Query: An error has occurred. - Request URL: undefined

Again, I can build a Skuid Platform page that displays data fine as long as all the columns (fields) in the object have a field name that doesn't have a [space] in it. Please, someone offer me a fix for this or I'll have to bail on Skuid altogether (and I really like the platform but am frustrated with the lack of support).
Photo of jdbuerger

jdbuerger

  • 502 Points 500 badge 2x thumb

Posted 1 year ago

  • 1
Photo of Zach McElrath

Zach McElrath, Employee

  • 49,056 Points 20k badge 2x thumb
Official Response
Based on the results provided by JD, our conclusion is that Skyvia's transformation of Zoho Contacts to OData is not going to be usable, as it does not appear to allow you to query for any field names containing spaces. In our opinion. I think that if you want to proceed further with exposing Zoho CRM data via OData, you'll need to work with another integration vendor, as Skyvia is not going to work.
(Edited)