This maybe not be possible but trying anyway. I have a Map Service with geometry features published. Two of the columns are 'Zone1' and 'Zone2' with values like 'ABC' or 'DEF'. The values of 'ABC' or 'DEF' can be present in both columns in the same row.
There is also a static 'lookup table' with a column named ZONECLASS and values like 'ABC' or 'DEF'. The static table is also published as layer in the along with the layer with geometry. So far so good.
What I am trying to do is that inside ArcGIS Online's Arcade Expression, query the static table's layer and get that data displayed inside ArcGIS Online. The query works in the browser as:
http://servicepath/MapServer/1/query?where=ZONECLASS=%ABC27&outFields=DOCNAME
But how to bring value of the DOCNAME field inside ArcGIS Online? I have built an expression as above url but that's just a string. I need to get the output.
Is that possible or do I need to seek an alternative solution?