Forum Discussion

tvinko's avatar
tvinko
Frequent Visitor
4 years ago

Display CSV from API

Hi all,   I'm new to PowerQuery and having troubles with displaying CSV that I get from API.  I'm using Business Central connector that returns me table with CSV text in rows. Is there any way to ...
Need Help
KNP's avatar
KNP
Super User
4 years ago

It's a bit of a guess and if it doesn't work I might need some screen shots at your 'myreports_table' step.

But try this first...

Change your above line to...

csv = myreports_table{fieldID}[myreport]

 I think fieldID needs to come before the column name.

Maybe. ğŸ¤”

tvinko's avatar
tvinko
Frequent Visitor
4 years ago

This is response that I get from BC:

Of course there could be many rows with CSV content in ReportInCSV column.

I get all csv texts from main table into list, but I need to loop through list and for each csv and create new table dynamically

 

  • KNP's avatar
    KNP
    Super User
    4 years ago

    I don't feel like I have enough of a complete picture.

    Are you able to post the complete M code as one block of code and a complete screen

    shot when you've selected the last auto generated step?

    Just blur/obfuscate any sensitive info.

     

    I feel like this should be easy to solve, I just don't have enough info.