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 I
Advocate I

@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

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (48,741)