cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
crob04
Frequent Visitor

Surveygizmo Webhook Payload Issue

Greetings,

 

I am working on a webhook listener for data being posted by SurveyGizmo.  

 

I only want to push data from a handful of questions (the survey has 1000+ fields) and the tool pushes the data over via a payload that looks like this: "First=Daniel&Question_SKU=104&Language=English" which is clearly not JSON (so generating a JSON schema for an HTTP connector is not an option).  

 

How do I work with a payload that looks like this using the http connector?  Is there a different connector I should be using?   When I made the endpoint a zapier endpoint, that tool has no issue whatsoever identifying the variable name and type but I can't get flow to work (and I need to use Microsoft specific connectors so zapier is not viable).  

webhook_site_screenshot.jpg

I look forward to the teams insights.

Chris

7 REPLIES 7
v-yamao-msft
Community Support
Community Support

Hi @crob04 ,

 

Do you want to work with Sruveygizmo?

 

It is currently not an available connector for Microsoft Flow, please submit an idea on Flow Ideas Forum if you need this feature:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Further, you could also consider creating a custom connector to work with Surveygizmo:

https://docs.microsoft.com/en-us/connectors/custom-connectors/

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Mabel,

 

I'm one of many who have requested integration already.

 

Also the ability to important Open API or Postman is limited to 1mb files and the API is much larger.  Creating a custom connector is outside of my skillset without a functioning import.


@v-yamao-msft wrote:

Hi @crob04 ,

 

Do you want to work with Sruveygizmo?

 

It is currently not an available connector for Microsoft Flow, please submit an idea on Flow Ideas Forum if you need this feature:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Further, you could also consider creating a custom connector to work with Surveygizmo:

https://docs.microsoft.com/en-us/connectors/custom-connectors/

 

Best regards,

Mabel

 



@v-yamao-msft wrote:

Hi @crob04 ,

 

Do you want to work with Sruveygizmo?

 

It is currently not an available connector for Microsoft Flow, please submit an idea on Flow Ideas Forum if you need this feature:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Further, you could also consider creating a custom connector to work with Surveygizmo:

https://docs.microsoft.com/en-us/connectors/custom-connectors/

 

Best regards,

Mabel

 


 

Hi @crob04 ,

 

Thanks for your understanding.

 

I will suggest other customers to vote your idea as well, PGs will take hot ideas into consideration first in future releases.

 

Further, I will help collect and report it on my side as well.

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
DarrenS
Advocate II
Advocate II

@crob04 hi, wondered if you found an alternative approach that you could share? Have identical issue with SG webhooks and Power Automate.

adaptimist
Regular Visitor

Hey there! I'm not sure if anyone's still paying attention to this thread but just in case, I've been able to do exactly this and wanted to share. The problem with SurveyGizmo/Alchemer's webhook output is, it's in urlencoded format which is tricky to deal with. You have to manipulate the string a bit first. Here's what I did:

 

1) Create a new flow with a HTTP Request trigger. When you save the flow, this will generate a URL that you can store in your SurveyGizmo/Alchemer survey as a webhook action (which will let you send over your survey data).

 

2) Create a Compose action with the following Expression:

base64ToString(trigger()['outputs']['body']['$content'])

 

This converts the webhook payload to plain text. Then you can manipulate it!

 

3) Create a second Compose action with the following Expression:

split(outputs('Compose'),'&')

 

This splits the payload up at every & character (assuming 'Compose' is the name of your first Compose action).

 

4) Initialize a Variable with type Array, with the Value set to the Outputs of the second Compose action.

 

Now you can refer to any data point within your payload using standard array notation (e.g., ArrayVar[1]).

 

I was able to make all kinds of neat stuff this way! 🙂

 

I hope that helps!

 

crob04
Frequent Visitor

Nicely done!  It does. I appreciate all the help.

Really appreciate the effort in sharing this approach @adaptimist. Have configured a survey to hit a power automate flow endpoint but am yet to explore by sending data through. Look forward to playing in the space in the near term. Thanks again.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (2,765)