topic Re: How to connect a database in json format to arcgis pro in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/how-to-connect-a-database-in-json-format-to-arcgis/m-p/207718#M9205 <HTML><HEAD></HEAD><BODY><P>Liliana, the Data Interoperability extension supports the creation of an ETL tool to import arbitrary JSON from file or URL, this brings access to the database into the geoprocessing environment.</P></BODY></HTML> Tue, 30 Apr 2019 14:15:56 GMT BruceHarold 2019-04-30T14:15:56Z How to connect a database in json format to arcgis pro https://community.esri.com/t5/arcgis-pro-questions/how-to-connect-a-database-in-json-format-to-arcgis/m-p/207716#M9203 <HTML><HEAD></HEAD><BODY><P>I have a url of a service in json format along with the body of the request, and I want to connect it with arcgis pro, I do not know how these tools are connected.<BR />Thank you <IMG src="https://community.esri.com/legacyfs/online/emoticons/happy.png" /> <IMG src="https://community.esri.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 29 Apr 2019 16:19:47 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-connect-a-database-in-json-format-to-arcgis/m-p/207716#M9203 CUARTA_OPORTUNIDADLOCAL 2019-04-29T16:19:47Z Re: How to connect a database in json format to arcgis pro https://community.esri.com/t5/arcgis-pro-questions/how-to-connect-a-database-in-json-format-to-arcgis/m-p/207717#M9204 <HTML><HEAD></HEAD><BODY><P>What is the JSON url? Your post contains very few details about the source data and the error you are encountering. Pro does not yet support direct consumption of GeoJSON, which is very unfortunate, however, your problem may be solved by one of the many comments in&nbsp;<A _jive_internal="true" href="https://community.esri.com/ideas/13080-arcgis-pro-direct-geojson-support">https://community.esri.com/ideas/13080-arcgis-pro-direct-geojson-support</A></P></BODY></HTML> Tue, 30 Apr 2019 11:16:56 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-connect-a-database-in-json-format-to-arcgis/m-p/207717#M9204 ThomasColson 2019-04-30T11:16:56Z Re: How to connect a database in json format to arcgis pro https://community.esri.com/t5/arcgis-pro-questions/how-to-connect-a-database-in-json-format-to-arcgis/m-p/207718#M9205 <HTML><HEAD></HEAD><BODY><P>Liliana, the Data Interoperability extension supports the creation of an ETL tool to import arbitrary JSON from file or URL, this brings access to the database into the geoprocessing environment.</P></BODY></HTML> Tue, 30 Apr 2019 14:15:56 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-connect-a-database-in-json-format-to-arcgis/m-p/207718#M9205 BruceHarold 2019-04-30T14:15:56Z Re: How to connect a database in json format to arcgis pro https://community.esri.com/t5/arcgis-pro-questions/how-to-connect-a-database-in-json-format-to-arcgis/m-p/207719#M9206 <HTML><HEAD></HEAD><BODY><P>Dear <A href="https://community.esri.com/migrated-users/3241">Bruce Harold</A>‌, can ETL tool convert JSON data just from nested node to FGDB table? I am not able to find appropriate tool in DI.</P><P></P><P>When using Attribute Creator tool, the outup fields are empty, or at best there is just one row. It seems like there is no iteartion.</P><P></P><P>Thank you.</P><P></P><P>Vladimir</P></BODY></HTML> Mon, 11 May 2020 10:21:24 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-connect-a-database-in-json-format-to-arcgis/m-p/207719#M9206 VHolubec 2020-05-11T10:21:24Z Re: How to connect a database in json format to arcgis pro https://community.esri.com/t5/arcgis-pro-questions/how-to-connect-a-database-in-json-format-to-arcgis/m-p/207720#M9207 <HTML><HEAD></HEAD><BODY><P>Hi Vladimir</P><P></P><P>You might have to take a couple of approaches.&nbsp; Just using a JSON reader does not unpack the properties.&nbsp; If the JSON contains an array then you may need to use a ListExploder to bring properties to top level or one of the JSON-based transformers to perform a query:</P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/491693_pastedImage_1.png" /></P><P>As JSON is a semantic format then handling what is in it needs to be custom.&nbsp; I attach an example FMW source where a CKAN JSON feed is turned into a feature service by way of example.</P><P>If you need help with this send me an email <A href="mailto:bharold@esri.com">bharold@esri.com</A>.&nbsp;</P></BODY></HTML> Mon, 11 May 2020 14:02:47 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-connect-a-database-in-json-format-to-arcgis/m-p/207720#M9207 BruceHarold 2020-05-11T14:02:47Z Re: How to connect a database in json format to arcgis pro https://community.esri.com/t5/arcgis-pro-questions/how-to-connect-a-database-in-json-format-to-arcgis/m-p/207721#M9208 <HTML><HEAD></HEAD><BODY><P>Dear <A href="https://community.esri.com/migrated-users/3241">Bruce Harold</A>‌,</P><P></P><P>awsome! Thank you so much. This is what I need!</P><P></P><P>Vladimir</P></BODY></HTML> Mon, 11 May 2020 14:59:48 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-connect-a-database-in-json-format-to-arcgis/m-p/207721#M9208 VHolubec 2020-05-11T14:59:48Z