Null values are getting inserted into sql table using logic app

Question

Hi All,

I have tried to create a logic app for HTTP request for inserting a row in sql table, but when the data is pushed through postman, null values are getting inserted instead of the values that i am posting.

HTTP Request JSON Body

{
"type": "object",
"properties": {
"Id": {
"type": "string"
},
"Name": {
"type": "string"
}
}
}

Values posted using Postman:

{
"Id":"10",
"Name":"Azure logic app"
}

Any suggestions please!

Answer 1

Hi @G Rohini Bharadwaja

I think I know what is going on

your content type is set to empty

try to change to this:

make sure it's all in one line and nothing left below

When I set my Postman like yours, I get nothing on my logic app:

-------------------------------

Here is my complete POSTMAN setup:

Make sure is "POST" , select body to add the json and select 'raw' and 'json""

minimun headers:

No Auth

Try again with those settings.

Case that information helps, don't forget to vote or mark as Answer to help the community. Cheers!