Forum Discussion

Willem_Plan-B_socks's avatar
Willem_Plan-B_socks
Copper Contributor
Aug 10, 2023

Webhook dynamic content turns to null

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
No RepliesBe the first to reply

Resources