Hey
Does anyone know if it is possible to use the SQL Server Insert Rows with a json object instead of having to fill in all of the individual fields in the logic app designer.
Eg :
I have a table in SQL MKTest1 that has 2 fields LogicAppId and RunDate.
Can I use the Data Operations / Compose shape or a Liquid Map to produce JSON like....
{
"LogicAppdId": "some logic apps id",
"RunDate": "20201-04-01 12:34:56"
}
I need to add data to a table with about 60 fields and don't want to have to manually do each field in LogicApps.
I cant use the FOR JSON function in SQL as this is a SQL Server 2012 instance.
My only other thought was to generate the code (using excel or something else easy) to look like the package in the "Code View" in Logic Apps
Eg :
{
"inputs": ``{
"body": {
"LogicAppId": "@variables('strLogicAppId')",
"RunDate": "@variables('strDate')"
}
Any thoughts on this and/or whether a feature to override the JSON Body would be useful.
Thanks as always for any comments / assistance.
Malcolm
