Forum Discussion

Darwood's avatar
Darwood
Frequent Visitor
1 year ago
Solved

Create Wallboard from API REST calls

How can I get the output of a Web Activity into a Lakehouse in Microsoft Fabric please?   A bit of background: I am trying to create a wallboard showing the status of our IT Infrastructure. One pa...
data hub
one lake
Real-Time hub
workspaces
  • nilendraFabric's avatar
    nilendraFabric
    1 year ago

    hello Darwood 

     

    I think you have done most of the hard work to get the authentication and connection done

     

    Now for Web Activity Output Handling
    • Use a Set Variable activity to capture the Web Activity response
    • Configure the variable to store the complete JSON output


    Create Copy Data Activity Setup
    • Create a dummy source query using a Fabric Datawarehouse connection
    • Use the “Additional Columns” section in the source to define your output schema
    • Configure the destination as the Lakehouse Files section
    • Map the fields from your variable to the destination columns

     


    check this discussion it will be helpful 

     

    https://community.fabric.microsoft.com/t5/Data-Pipeline/Writing-Pipeline-Output-to-JSON-file-in-Lakehouse/m-p/4117453

     

     

    If this helps. Please accept the solution 

     

    Thanks

nilendraFabric's avatar
nilendraFabric
Icon for Super User rankSuper User
1 year ago

hello Darwood 

 

I think you have done most of the hard work to get the authentication and connection done

 

Now for Web Activity Output Handling
• Use a Set Variable activity to capture the Web Activity response
• Configure the variable to store the complete JSON output


Create Copy Data Activity Setup
• Create a dummy source query using a Fabric Datawarehouse connection
• Use the “Additional Columns” section in the source to define your output schema
• Configure the destination as the Lakehouse Files section
• Map the fields from your variable to the destination columns

 


check this discussion it will be helpful 

 

https://community.fabric.microsoft.com/t5/Data-Pipeline/Writing-Pipeline-Output-to-JSON-file-in-Lakehouse/m-p/4117453

 

 

If this helps. Please accept the solution 

 

Thanks

Darwood's avatar
Darwood
Frequent Visitor
1 year ago

Ignore that last message. I didn't realise the output wrapped the result in a JSON object with a "response" property. I have updated the variable expression to 

@json(activity('Devices').output.response) and the array variable seems to be correctly populated now. Still struggling to get the Additional Columns working in the Copy Data activity though...