Forum Discussion

bwash615's avatar
bwash615
Copper Contributor
May 27, 2021

Logic App with Azure Table Query - Return only value

Hello,

 

I am working with Azure Tables as part of a larger effort involving cognitive services. I am very unfamiliar with how to query NoSQL, which is probably why I'm having difficulties. Essentially, I am trying to query an azure table and just replace all the values in 1 column (I know their not called columns, but that's how I see it). If I simply try to replace the field in the entity with a 'Replace' function, it kills all the other columns. I have tried to replace and rebuild the table by initializing variables to capture the original values of the fields I want to retain before the replace statment. This almost works except that it returns the full metatadata and the value (see below). I just want the actual value i.e. '9'. I tried adding an 'odata=nometadata' parameter to the 'Get Entity' component, but it says it's not a valid json. 

 

{"odata.metadata":"https://qwkstest.table.core.windows.net/$metadata#res3SkillsetDocument/@Element&$select=ADPID%22,%22odata.etag%22:%22W/\%22datetime%272021-05-27T18%3A59%3A29.5415156Z%27\%22%22,%22ADPID%22:%229%22%7D
 
Any thoughts would be much appreciated!

 

No RepliesBe the first to reply