I have created a flow in power automate that triggers when data is recieved via a http request (webhook).
When I recieve a request the data looks very good, but when I try to use the data it turns this data into null.
Example:
Json schema input:
{
"schema": {
"type": "object",
"properties": {
"headers": {
"type": "object",
"properties": {
**header properties**
},
"body": {
"type": "object",
"properties": {
"id": {
"type": "integer"
},
**Rest of the body**
This is how the data is received, as a nice dataset:
{
"headers": {
not relevant
},
"body": {
"id": 5704,
etc.
When using this id from the body to search for example in an excel sheet. It does this:
{
"host": {
"connectionReferenceName": "shared_excelonlinebusiness",
"operationId": "GetItem"
},
"parameters": {
"source": "not relevant",
"drive": "not relevant",
"file": "not relevant",
"table": "not relevant",
"idColumn": "ID",
"id": null
}
}
Can someone please help me with this problem, I have tried a lot of things, but can't get it to work.
Thanks in advance
