online automate data update

Hi, I need some help with automating a dashboard.

I have created it in the desktop version and want the data to automatically update every night.

The only data source I am using is a homebuilt api that I can connect to via “web” data sources and it uses the field http ‘Authorization’ then value and my key. That works great in the desktop version.

But I am unable to connect to that data source via the web interface after I set up the gateway. When I choose Web under Data source settings I don’t get the Authorization field to fill in and I tried all the combinations of url : value : key I could think about.

Is there any other way that I can make the data update to get the latest values with me having to do it via the desktop and re-publishing it?

Any help would be appreciated.