planningcenter / developers

Planning Center API docs and support
https://developer.planning.center/docs/
85 stars 8 forks source link

Using JSON payload in MS Flow #1172

Closed philfbcnz closed 5 months ago

philfbcnz commented 5 months ago

Related Product Which product is this question related to? People API

Describe the question I am trying to create a flow in Power Automate which adds a new row in a table when a person is added into People. For the life of me, I can not figure out how to get the actual values out of the JSON and into the table, it just keeps giving blanks.

For testing purposes, I am using a Compose action to simulate the http webhook.

image image image image image image image

I realize this is not an API issue but more of a lack of understanding of things.

Any help would be much appreciated please.

Thanks, Phil.

I have..

seven1m commented 5 months ago

I'm sorry, but I'm not familiar with this product, and I don't think we have anyone on staff who is. My only suggestion might be to start at the top and see if you can extract something like the data object. And if that works, you could work on extracting data.type (which would give you "Person"). And last, you could work on extracting data.attributes.first_name. I'm sorry I can't be of more help!