Add JSON or geoJSON Layer to ArcGIS Online Map from CartoDB REST Endpoint?

Question

Is it possible to use a CartoDB REST endpoint that emits JSON or geoJSON as a layer in my ArcGIS Online map?

It thought there would be something like Add Layer From Web - geoJSON

Thank you -- Tom

ThomasColson · Answer

You can, in theory, do this by building a CartDB SQL Query which outputs KML, such as https://nps.cartodb.com/api/v2/sql?filename=NPS_Roads&format=kml&q=SELECT+*+FROM+roads%20where%20unit_code%20=%20%27grsm…

and then adding a kml link. Similar to adding a network link to Google Earth

AdamJoseph1 · Answer

If you can extend koop to do this job or as an alternative export your data to cartoview and

serve ArcGIS Server REST compatible services from cartoview

BrianFlood · Answer

you can use esri's koop as an intermediary service for geojson

Esri/koop · GitHub