Remtoe dataset and Smartsheet.com

Ok I am stuck. I am trying to get a POC done with Xibo before we I present costs of using the cloud version but I am stuck on one piece.

I am trying to get data from a remote dataset that is stored in a sheet on smartsheet.com. I am not sure what needs to go where. When I attempt to make a call using the URL: https://api.smartsheet.com/2.0/sheets/(sheet #) in something like postman I have to add the authentication API key. So the call has header values such as
Authorization = Bearer
Content-Type = application/json

the query in postman works fine. I am not sure how to translate in to something that Zibo can use to grab the data from the sheet like I want.

There is the Authentication tab when you edit remote dataSet, that could potentially be what you need - unfortunately I’m not familiar with that website to tell what auth do they use as such I’m also not sure how does the .json with actual data looks like, but perhaps manual page for dataSets will help you will configuration of your remote dataSet - https://xibo.org.uk/manual/en/media_datasets.html

I looked at the instructions before I posted for help. LOL

Their authentication for getting the data is via an API key. I will try setting up another user and see if it will grab the data that way. This is the last piece before I present and push out across our organization.

Hi,

Did you manage to get the data via API Key?