Query a JOINED ArcGIS Online resultset (via an HTTP request)

Question

In a related question, we determined that it's possible to query an ArcGIS Online FC via an HTTP request.
(I'll refer to the feature class as FC1.)
In addition to the above, I want to dynamically join from FC1 to a second feature class called FC2.

The join could be described as: Left join FC1 to FC2 on FC1.ID = FC2.ID.

Can such a join be performed in ArcGIS Online -- in a way that allows the resultset to be served up to an external system? (as a JSON object that is requested via HTTP)

User1973 · Accepted Answer

The Join Features tool seems to have worked:
Steps:

Add a feature layer to a web map by using the Join Features tool.

Note: I couldn't find the Content --> Analysis button in the new Web Map Viewer (Beta).
I had to use the classic Web Map Viewer instead.

Create an application to authorize HTTP requests to AGOL

Query an ArcGIS Online FC via an HTTP request
Use the Feature Service URL from the new join feature layer.

And yes, the resulting feature layer is indeed dynamic.
I tested a few edits, and when I query the joined feature layer using the aforementioned HTTP solution, the JSON response does, in fact, show  the updated data from the joined columns. So it worked as expected.

From the Join Features tool (ArcGIS Online):
"Create results as a hosted feature layer view allows the data to stay up
to date as the source data changes."
https://doc.arcgis.com/en/arcgis-online/analyze/join-features.htm

Query a JOINED ArcGIS Online resultset (via an HTTP request)

One Answer

Add your own answers!

Ask a Question