https://community.dynatrace.com/t5/Dynatrace-API/Looking-for-an-API-ETL-tool-for-JSON-data-returned/m-p/289300#M3873 <P>Good morning fellow Dynatracers? Dynatrac-ians? (Whichever you prefer)&nbsp;‌‌</P> <P>First off we have an on prem solution for Dynatrace.</P> <P>We have several 3rd party vendors that are making performance and monitoring data available through<BR />their own crafted API interface. I have read over and am familiar with the part of Dyaatrace's API that<BR />allows a person to post data into the Dynatrace DB/on-prem cluster to then be used with the Data explorer<BR />tool OR pulled out of Dynatrace with their own API.</P> <P>What I am looking for is&nbsp;a generic tool that can handle going out to an API and retrieve the data.&nbsp;I know curl does exactly this.</P> <P>However, the challenge we have is processing the returned response/information afterwards.</P> <P>Let's say I run a curl command, get my JSON data back. At that point, the data<BR />is at the command line (or a file if I send the output there).<BR />Is there a tool that specializes in taking this JSON data and ETL'ing the results?</P> <P><BR />If there is a tool that does both the curl command AND ETL of the responses, that would be ideal<BR />(we would want to run this on regular intervals in cron etc..)</P> <P>Do such tools exist? I'm trying to find a low code/programming solution to taking<BR />data from multiple API sources and processing it down to a file that I can then post in to Dynatrace.</P> <P>Linux would be idea, but windows is also an option. Maybe even windows as preferred if a gui<BR />is an option. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> <P>This is a gap in my knowledge, so I am looking for suggestion to help with<BR />these upcoming projects.</P> <P>As always, thanks to the community for being as supportive and engaging !</P> Wed, 12 Nov 2025 07:40:13 GMT runatyr 2025-11-12T07:40:13Z https://community.dynatrace.com/t5/Dynatrace-API/Looking-for-an-API-ETL-tool-for-JSON-data-returned/m-p/289300#M3873 <P>Good morning fellow Dynatracers? Dynatrac-ians? (Whichever you prefer)&nbsp;‌‌</P> <P>First off we have an on prem solution for Dynatrace.</P> <P>We have several 3rd party vendors that are making performance and monitoring data available through<BR />their own crafted API interface. I have read over and am familiar with the part of Dyaatrace's API that<BR />allows a person to post data into the Dynatrace DB/on-prem cluster to then be used with the Data explorer<BR />tool OR pulled out of Dynatrace with their own API.</P> <P>What I am looking for is&nbsp;a generic tool that can handle going out to an API and retrieve the data.&nbsp;I know curl does exactly this.</P> <P>However, the challenge we have is processing the returned response/information afterwards.</P> <P>Let's say I run a curl command, get my JSON data back. At that point, the data<BR />is at the command line (or a file if I send the output there).<BR />Is there a tool that specializes in taking this JSON data and ETL'ing the results?</P> <P><BR />If there is a tool that does both the curl command AND ETL of the responses, that would be ideal<BR />(we would want to run this on regular intervals in cron etc..)</P> <P>Do such tools exist? I'm trying to find a low code/programming solution to taking<BR />data from multiple API sources and processing it down to a file that I can then post in to Dynatrace.</P> <P>Linux would be idea, but windows is also an option. Maybe even windows as preferred if a gui<BR />is an option. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> <P>This is a gap in my knowledge, so I am looking for suggestion to help with<BR />these upcoming projects.</P> <P>As always, thanks to the community for being as supportive and engaging !</P> Wed, 12 Nov 2025 07:40:13 GMT https://community.dynatrace.com/t5/Dynatrace-API/Looking-for-an-API-ETL-tool-for-JSON-data-returned/m-p/289300#M3873 runatyr 2025-11-12T07:40:13Z https://community.dynatrace.com/t5/Dynatrace-API/Looking-for-an-API-ETL-tool-for-JSON-data-returned/m-p/289410#M3874 <P>Hi,<BR />You can try&nbsp;<STRONG>Logstash</STRONG> with plugins: http_poller (input) → json / mutate / ruby (filter) → http (output to Dynatrace).</P><P>or&nbsp;<STRONG>n8n</STRONG>: Cron → HTTP Request → Set / Function / IF → HTTP Request (Dynatrace).</P> Wed, 12 Nov 2025 08:32:20 GMT https://community.dynatrace.com/t5/Dynatrace-API/Looking-for-an-API-ETL-tool-for-JSON-data-returned/m-p/289410#M3874 t_pawlak 2025-11-12T08:32:20Z