topic Re: Retrieve data from third-party API using Basic Authentication, display as feature layer? in ArcGIS Online Questions

Retrieve data from third-party API using Basic Authentication, display as feature layer?

JackSilburn — Fri, 24 Jan 2020 02:11:54 GMT

I am curious to know if it is possible to do the following:

create an ArcGIS Online item/feature/application which calls a non-ArcGIS API endpoint,
the API returns a JSON response when queried,
the API also requires Basic Authentication.

The data is interpreted as an ArcGIS Online 'friendly' format (e.g. feature layer? Table?), which can then be added to Web Maps, Applications, Ops Dashboard etc.

Thanks

Re: Retrieve data from third-party API using Basic Authentication, display as feature layer?

Anonymous User — Thu, 23 Apr 2020 15:42:57 GMT

Hi Jack Silburn‌,

Thanks for the post. Were you able to get this to work?

I think this question ultimately depends on the JSON response when queried. From this doc, if the response is valid GeoJSON then you would be able to add it to a web map and create a hosted feature layer: What can you add to ArcGIS Online?—ArcGIS Online Help | Documentation; Import data | ArcGIS for Developers

Developer Communities‌ would maybe have more to add on the authentication component.

Hope this helps,

-Peter

Re: Retrieve data from third-party API using Basic Authentication, display as feature layer?

JackSilburn — Tue, 28 Apr 2020 02:07:41 GMT

Hi Peter

I ended up following a fairly convoluted (and bespoke) process:

I am using a linux server to run a python program on an automated schedule
The program handles the API requests, using the Python Requests module, to return JSON data
The program then queries the AGOL API, returning a list of GIS features and associated primary keys
The program joins the two datasets from steps 2 & 3, and POSTs the completed table back to AGOL, via the UpdateFeatures API method.

I now have a feature layer which is updated automatically with 'live' data, which I can use in Web Maps and so forth.

I believe I tried something following your first link, but for whatever reason it wasn't working out.

Thanks

Re: Retrieve data from third-party API using Basic Authentication, display as feature layer?

Anonymous User — Tue, 28 Apr 2020 21:46:00 GMT

Hi Jack,

Thanks for following up on this - I'll go ahead and mark your answer as correct to help anyone else that comes across the thread; as you mention it is customized for your scenario but I suspect other folks have similar end goals.

If you haven't yet I would recommend checking out Notebooks beta and trying it our for some of your workflows - it provides access to the ArcGIS API for Python and general Python functions in the cloud.

Cheers,

-Peter

Re: Retrieve data from third-party API using Basic Authentication, display as feature layer?

NaomiOmwebu — Thu, 10 Nov 2022 11:53:49 GMT

Hi,

I am attempting to a similar task- but I am not able to follow your workflow. I want to call a non ArcGIS REST API, and would like to view and query the live data in ArcGIS pro or online, as well as overlay other different datasets/layers. I am using Windows 10.