title: Snowflake:How to read the data which is in JSON format but it is wrapped in an XML response
body: <p>I get the data response from API as XML with JSON data in it</p>
  <p>How can I achieve reading the JSON data using Snowflake to load into the table?</p>
  <pre><code>&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;
  &lt;soap:Envelope xmlns:soap=&quot;http://schemas.xmlsoap.org/soap/envelope/&quot; xmlns:xsi=&quot;http://www.w3.org/2001/XMLSchema-instance&quot; xmlns:xsd=&quot;http://www.w3.org/2001/XMLSchema&quot;&gt;
      &lt;soap:Body&gt;
          &lt;GetFilteredResponse xmlns=&quot;Log_EngIP&quot;&gt;
              &lt;GetFilteredCustomReportResult&gt;
                  &lt;DtoObject&gt;
                      &lt;ReportData&gt;[{&quot;ID&quot;:1,&quot;Name&quot;:&quot;Default&quot;,&quot;OwnerID&quot;:1,&quot;SortOrder&quot;:null,&quot;Terms&quot;:&quot;+0&quot;},{&quot;ID&quot;:3,&quot;Name&quot;:&quot;VIP&quot;,&quot;OwnerID&quot;:1,&quot;SortOrder&quot;:null,&quot;Terms&quot;:&quot;+30&quot;},{&quot;ID&quot;:9,&quot;Name&quot;:&quot;Telesphere (EmailAndStatus)&quot;,&quot;OwnerID&quot;:1,&quot;SortOrder&quot;:0,&quot;Terms&quot;:&quot;+0&quot;},{&quot;ID&quot;:10,&quot;Name&quot;:&quot;Default&quot;,&quot;OwnerID&quot;:693,&quot;SortOrder&quot;:null,&quot;Terms&quot;:&quot;+30&quot;}]&lt;/ReportData&gt;
                      &lt;NumberOfPages&gt;1&lt;/NumberOfPages&gt;
                  &lt;/DtoObject&gt;
                  &lt;Response&gt;Successful&lt;/Response&gt;
                  &lt;Successful&gt;true&lt;/Successful&gt;
              &lt;/GetFilteredCustomReportResult&gt;
          &lt;/GetFilteredResponse&gt;
      &lt;/soap:Body&gt;
  &lt;/soap:Envelope&gt;
  </code></pre>