Kris,
Thanks so much for your reply!
Here is a little bit of the background -
Goal: When a new Wufoo survey entry is submitted, create a Sharepoint List entry.
So far: I tried two routes.
- I created a custom connector in Flow to connect to the Wufoo api which can use json or xml. I constructed the url requests to use json. I have been able to use the api piece with the custom connector. Using this method I believe I would need to use a timer to trigger regular calls to check for new entries.
- Wufoo has a webhook piece which you can enter the URL in Wufoo of where to send the request to. My thought was that using this as the trigger for the flow would be better than using a timer. I was also thinking that in using this, I would then not even need to use the custom connector (although I'm proud of myself for successfully making the custom connector as a novice user). The webhook from Wufoo is sending the data as a content type of x-www-url-formencoded rather than json. I'm struggling to understand how to pull the data out of the body result that is being sent.
Here is the setup I have been using to test the flow until I figure out how to separate the fields.
- When HTTP Request is Received
- Compose
- Email
I found that if I put the whole body result from HTTP Request in the email it includes the whole package along with Key, Value pairs. This made me think that if I could extract it as some sort of array then I could identify the fields. I then found that I could use triggerFormDataValue('Name of Key here') to grab the value associate with the that particular key. There are about 20 key/value pairs so I was hoping to have some sort of function that could automatically grab the entire set of key/value pairs without needing to specify each individual one as I was also hoping to use this flow for other surveys which would use different key/value pairs.
Another option I was thinking is I could extract the ID of the survey entry using the FormDataValue piece from above and then use the custom connector to grab the entry for that survey. It seems like this would be a waste though since the data is already there, I just am struggling to format it correctly.
Nick
