Question

Create FreshService ticket with PowerAutomate "Requester ID"

  • 8 September 2021
  • 4 replies
  • 284 views

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.


4 replies

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.

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

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

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.

Reply