Parse JSON array to Azure Table Storage

Question

Good morning,

I am trying to export a list from Sharepoint to Azure Table Storage by using JSON array.
It looks like the array contains several object, each object having parameters such ass "name", "address" etc.

The store-to-azure-table function in Logic App seems to expect receiving an object, not an array.
How do we extract each object from the JSON array?

Best regards,
Jakob

Answer

Hi @Jakob Rognlien - You would need to deflate the json and create columns. Please see the following Stack Overflow post: Storing JSON data as columns in Azure table storage

This is achieved through JSON.stringify(someContext) and then map the functions to columns through an Azure Logic App example:

module.exports = function (context, someContext) {  
   context.log('Message received: ' + JSON.stringify(someContext));  
   var deviceData = {  
   "partitionKey": moment.utc().format('YYYYMMDD'),  
      "rowKey": moment.utc().format('hhmmss') + process.hrtime()[1] + '',  
   };  
   Object.keys(someContext).forEach(function(key) {  
     deviceData[key] = someContext[key];  
   });  
   context.bindings.deviceData = deviceData;  
   context.done();  
};

I hope this helps.

Regards,
Mike

Parse JSON array to Azure Table Storage

1 answer