https://community.qlik.com/t5/Integration-Extension-APIs/REST-API-Not-reading-column-names-in-response/m-p/2120191#M19204 <P>Hi All,</P> <P>Please advise on below. I am trying to read data from Microsoft Teams Auto Attendant.&nbsp;</P> <P>I configured a REST connection and I am able to successfully connect. The query is sent as a parameter encoded in Base64.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="wcilliers_0-1695179319202.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/116617i9579292B889AB958/image-size/medium?v=v2&amp;px=400" role="button" title="wcilliers_0-1695179319202.png" alt="wcilliers_0-1695179319202.png" /></span></P> <P>&nbsp;</P> <P>BUT, when I select data, I am not getting any column names back and row data is loaded in pivot.&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="wcilliers_1-1695179395770.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/116618iC1B2558BE96E8DD1/image-size/medium?v=v2&amp;px=400" role="button" title="wcilliers_1-1695179395770.png" alt="wcilliers_1-1695179395770.png" /></span></P> <P>&nbsp;</P> <P>Is there a way to get the column names and ideally in the correct format?</P> <P>This is what it looks like in Power BI, for the exact same query...</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="wcilliers_2-1695179512603.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/116619i9D448CB3479128EA/image-size/medium?v=v2&amp;px=400" role="button" title="wcilliers_2-1695179512603.png" alt="wcilliers_2-1695179512603.png" /></span></P> <P>&nbsp;</P> <P>Any ideas?</P> <P>Thank you,</P> <P>Wynand</P> <P>&nbsp;</P> Wed, 20 Sep 2023 03:13:30 GMT wcilliers 2023-09-20T03:13:30Z https://community.qlik.com/t5/Integration-Extension-APIs/REST-API-Not-reading-column-names-in-response/m-p/2120191#M19204 <P>Hi All,</P> <P>Please advise on below. I am trying to read data from Microsoft Teams Auto Attendant.&nbsp;</P> <P>I configured a REST connection and I am able to successfully connect. The query is sent as a parameter encoded in Base64.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="wcilliers_0-1695179319202.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/116617i9579292B889AB958/image-size/medium?v=v2&amp;px=400" role="button" title="wcilliers_0-1695179319202.png" alt="wcilliers_0-1695179319202.png" /></span></P> <P>&nbsp;</P> <P>BUT, when I select data, I am not getting any column names back and row data is loaded in pivot.&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="wcilliers_1-1695179395770.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/116618iC1B2558BE96E8DD1/image-size/medium?v=v2&amp;px=400" role="button" title="wcilliers_1-1695179395770.png" alt="wcilliers_1-1695179395770.png" /></span></P> <P>&nbsp;</P> <P>Is there a way to get the column names and ideally in the correct format?</P> <P>This is what it looks like in Power BI, for the exact same query...</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="wcilliers_2-1695179512603.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/116619i9D448CB3479128EA/image-size/medium?v=v2&amp;px=400" role="button" title="wcilliers_2-1695179512603.png" alt="wcilliers_2-1695179512603.png" /></span></P> <P>&nbsp;</P> <P>Any ideas?</P> <P>Thank you,</P> <P>Wynand</P> <P>&nbsp;</P> Wed, 20 Sep 2023 03:13:30 GMT https://community.qlik.com/t5/Integration-Extension-APIs/REST-API-Not-reading-column-names-in-response/m-p/2120191#M19204 wcilliers 2023-09-20T03:13:30Z