Error fetching data from API. Exception details: SyntaxError: Unexpected token:

  • 20Views
  • Last Post 19 May 2022
0
votes
Alexander Fairfax posted this 18 May 2022

I went to connect a new oData endpoint to a Google Data Studio project using the Skyvia Connect communicty connector. When I provide the endpoint URL and (correct) credentials I now get the following error:

Debug
Skyvia Connect by Skyvia

Error fetching data from API. Exception details: SyntaxError: Unexpected token: <

I had a look at the endpoint's $metadata schema and it's returning XML. Could it be that Skyvia Connect is expecting JSON? It was all working for me prevously. Many thanks

 

0
votes
Nataliia Nikulina posted this 19 May 2022

Hello Alexander, 

Thank you for contacting Sykvia Support team. 

To analyze your data with Google Data Studio, you need to create an SQL endpoint first and obtain its URL.

https://docs.skyvia.com/connect/sql-endpoints/

Then you can use this URL in the connector.

We would recommend you to view the instructions on how to connect to  Google Data Studio with Skyvia.

https://docs.skyvia.com/connect/sql-endpoints/google-data-studio-connector.html

Should you have any further questions, let us know. 

Best regards, 

Nataliia

 

 

Close