Visit Freshworks.com Visit Freshworks
Question

Create FreshService ticket with PowerAutomate "Requester ID"

  • 8 September 2021
  • 5 replies
  • 588 views
S
Rank
Userlevel 1
Badge

So I am working on automating some things as far as our user creations. So when I select the “Create a Ticket” action in Power Automate it makes me select a requester ID from a predone list, I assume an import from FreshService users. I can select “Custom” but it only allows an Integer field so I can’t select the requester from the form the data is coming from “Microsoft Forms”.

Anyone have any ideas what exactly it needs in order for me to make the ticket come from the person that filled out the Microsoft Form or for it to at least work? No matter what I try, it fails due to it not being an integer.

5 replies

P
Rank
Userlevel 3
Badge +9

@Schwiftyyy What you need to do is a lookup against the UPN from Forms in Freshservice to get the Requester ID.

https://youraddress.freshservice.com/api/v2/requesters?query=%22primary_email:%27EMAILOFUSER@DOMAIN.COM%27%22

Then get the requester ID and feed it to the next step of your Automation.

Asimraza89
Rank

I was looking for answer too thanks for sharing. Really Appreciated.I 

AndrewBCC
Rank

@Schwiftyyy What you need to do is a lookup against the UPN from Forms in Freshservice to get the Requester ID.

https://youraddress.freshservice.com/api/v2/requesters?query=%22primary_email:%27EMAILOFUSER@DOMAIN.COM%27%22

Then get the requester ID and feed it to the next step of your Automation.

How did you take the requester ID and transport that information over to power automate? When i try this, I get the error that the email needs to be in a valid format. Meaning that it will only take the requester ID. Any other value in that area throws errors.

P
Rank
Userlevel 3
Badge +9

@Schwiftyyy What you need to do is a lookup against the UPN from Forms in Freshservice to get the Requester ID.

https://youraddress.freshservice.com/api/v2/requesters?query=%22primary_email:%27EMAILOFUSER@DOMAIN.COM%27%22

Then get the requester ID and feed it to the next step of your Automation.

How did you take the requester ID and transport that information over to power automate? When i try this, I get the error that the email needs to be in a valid format. Meaning that it will only take the requester ID. Any other value in that area throws errors.

Andrew,

It’s a multi-part flow you need to build.  The first part is converting the requester ID to an email address.  So take that URL that I gave you and put in the email address of the user.  You can then parse that data to get the requester ID.  Now once you have the ID you can pass that to Freshservice.  You can also reverse that and put in the requester ID and get the email from it by changing the URL  https://yourdomain.freshservice.com/api/v2/requesters/REQUESTERID

Does this make sense to you?  If you need some additional assistance let me know.

N
Rank
Badge

@Schwiftyyy What you need to do is a lookup against the UPN from Forms in Freshservice to get the Requester ID.

https://youraddress.freshservice.com/api/v2/requesters?query=%22primary_email:%27EMAILOFUSER@DOMAIN.COM%27%22

Then get the requester ID and feed it to the next step of your Automation.

How did you take the requester ID and transport that information over to power automate? When i try this, I get the error that the email needs to be in a valid format. Meaning that it will only take the requester ID. Any other value in that area throws errors.

Andrew,

It’s a multi-part flow you need to build.  The first part is converting the requester ID to an email address.  So take that URL that I gave you and put in the email address of the user.  You can then parse that data to get the requester ID.  Now once you have the ID you can pass that to Freshservice.  You can also reverse that and put in the requester ID and get the email from it by changing the URL  https://yourdomain.freshservice.com/api/v2/requesters/REQUESTERID

Does this make sense to you?  If you need some additional assistance let me know.

I’m going through a similar issue but instead I’m trying to have a ticket created when a post is made in a Teams channel. The requester id field doesn’t let me put anything in because it’s expecting an integer and I’m just not sure what it’s asking for as I’m very new to Automate. Do you have any suggestions?

Reply


Terms of UseCookie settings