Surveygizmo Webhook Payload Issue

(1) Share

Report

Posted on by crob04

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).

I look forward to the teams insights.

Chris

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

v-yamao-msft on at

Like (0)

Report

Re: Surveygizmo Webhook Payload Issue

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

Was this reply helpful? Yes No
crob04 8 on at

Like (0)

Report

Re: Surveygizmo Webhook Payload Issue

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

Was this reply helpful? Yes No
v-yamao-msft on at

Like (0)

Report

Re: Surveygizmo Webhook Payload Issue

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

Was this reply helpful? Yes No
DarrenS 35 on at

Like (0)

Report

Re: Surveygizmo Webhook Payload Issue

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

Was this reply helpful? Yes No
adaptimist 6 on at

Like (2)

Report

Re: Surveygizmo Webhook Payload Issue

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!

Was this reply helpful? Yes No
crob04 8 on at

Like (0)

Report

Re: Surveygizmo Webhook Payload Issue

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

Was this reply helpful? Yes No
DarrenS 35 on at

Like (0)

Report

Re: Surveygizmo Webhook Payload Issue

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.

Was this reply helpful? Yes No