Airtable datasource ?

Josselin Granger shared this question 28 days ago
Awaiting Reply

Hi everyone,

has anyone been able to connect Yellowfin to an airtable datasource through the JSON connector ?

I'm struggling with this (but I must admit JSON data source is not my field of expertise).

Thanks for your help

Comments (9)

photo
1

Hi Josselin,

Thanks for reaching out to support with your issue.

I'm thinking you have found our knowledge base guides found here-

https://community.yellowfinbi.com/knowledge-base/article/json-connector

https://community.yellowfinbi.com/knowledge-base/article/what-is-a-json-data-type-and-does-yellowfin-support-it

https://community.yellowfinbi.com/knowledge-base/article/n-a_2

I see nothing on file indicating our product has been used with Airtable before, but I'll reach out to the team to find out. If no one has experience here, I would have to get access to an Airtable environment to do some testing. This may be helpful in the meantime-

https://medium.com/row-and-table/an-basic-intro-to-the-airtable-api-9ef978bb0729

Dealing with JSON connectors can be pretty time consuming, perhaps you could look into the possibility of using a 3rd party JDBC connector, or a Data Warehouse solution, as an alternative?

Thanks,

Eric

photo
1

Hi Eric,

I did read all that, along with the Airtable API Documentation, which is pretty clear.

When I set the query I in Postman I get a response with all my data. Easy.

In Yellowfin JSON connector I chose the following options :

- Data source : REST API

- End Point URL : The URL to my database, given by Airtable

- Headers List : Authorization: Bearer <MY_API_KEY>

I left the others fields blank (or with their default values), and when I hit "validate URL" I receive the message "REST Error : Invalid Rest Configurations"

photo
1

HI Josselin,

Thanks for the additional info here. We might be able to get more information about what is wrong with the "invalid REST Configurations" on the receiving side; would you be able to provide any output from Airtable's side during this operation?

I touched based with an implementation specialist, who shared the sentiment of looking at the possibility of using a 3rd party JDBC connector such as C-Data:

https://www.cdata.com/drivers/airtable/jdbc/

I've reached out to your Account Manager to see if we can arrange an engagement to discuss objectives and solutions further.

Thanks,

Eric

photo
1

Hi Eric,

Thanks for your link, but I don't currently have the budget to purchase additional 3rd-party components (this one is currently in beta, but will then be highly priced), nor would it be relevant anyway in a simple ROI perspective.

I attached to this reply the response I get from Airtable when I use postman with the same configuration : API url + "Authorization : Bearer XXXX" header.

photo
1

Hi Josselin,

Would you be able to temporarily put your yellowfin application server in DEBUG mode, and provide a compressed copy of the logs folder, along with a timestamp of when you got the error message? More info can be found here -

https://community.yellowfinbi.com/knowledge-base/article/how-do-i-turn-on-debug-logging-within-yellowfin-log-file

please be sure to disable debug logging again after obtaining the logs folder:

<yellowfin>/appserver/logs

If this file is too large to attach here you can upload to our ftp - https://ftp.yellowfin.bi - just use the "upload files" button.

I'm experiencing similar issues in my Airtable testing so far. This may indicate there is an issue with the JSON connector and Airtable, or how Yellowfin is handling security for the Airtable authentication.

Thanks,

Eric

photo
1

Hi Josselin,

Just wanted to check in to see if you had a chance to review my response at this time?

Thanks,

Eric

photo
1

Hi Eric,

No, not yet. This past week has been pretty busy/weird due to the lockdown.

I may have some time tomorrow or next week, but with no certainty.

(btw, I still don’t have any solution on my licensing problem)

Regards

7478225b187cb14e4bcf1271145ba18b

Josselin GRANGER

Chief Product Officer

21 Rue Commandant Fuzier - 69003 Lyon

Tél : 07.79.46.57.94 / 04.72.77.16.03

josselin.granger@easy-life.fr

www.easy-life.fr

ac23bf8a416e7423921eb720f12d260b

De : Support Queue [mailto:support@Yellowfin.bi]

Envoyé : jeudi 19 mars 2020 15:57

À : Josselin GRANGER <josselin.granger@easy-life.fr>

Objet : New Comment in "Airtable datasource ?"

photo
1

Hi Josselin,

Thanks for the update. I can definitely relate to your week! Hope you're well in spite of the circumstances.

If you're able to get the Debug logs, great, if not, no worries, I can keep doing some testing on my end with my connection. Although I only have a few days left of my trial haha!

Big picture-wise, it feels like we might need to make changes to the JSON connector, or even devise our own proper "connector" for Airtable in order for this authentication to get sorted. In the meantime there might be a way to "pull" the data in a different way, so that Yellowfin can access it. Of course a JDBC "helper" was my first idea, but there may be another option, such as implementing a data warehouse solution. Would this be something to look into potentially?

Thanks,

Eric

photo
1

Hi Josselin,

Hope you are well, just wanted to check in to see if you had a chance to review y reply in this case?

Thanks,