Saving the iftttResult_variable to the Confiform Table

[Erin Smith]

I have a Confiform conundrum I'm hoping you can help me with. We have a form that creates a JIRA issue and stores that result in the variable JIRAID. We can pass that result to an IFTTT generated email using $iftttResult_JIRAID, but we also want to set a variable value so the result is passed to the Confiform table. When we use the Confiform Rules for Form Field macro to set the variable JID=$iftttResult_JIRAID it doesn't pass the actual result just the text $iftttResult_JIRAID.

 

IFTTT Event *onCreated

Choose Action to perform *Create JIRA Issue

Set custom name for this action result (alphanumeric, no spaces) *JIRAID

We've tried changing the type of field JID is (Text vs JIRA Issue) as well as changing the location of the rule that sets JID to the JIRAID result (inside the IFTTT vs just after the IFTTT) but nothing seems to work.

I'm sure it's just a simple fix, but for the life of me we can't figure it out.

Any assistance you can provide would be appreciated.

[Alex Medved _ConfiForms_]

You need to store the result of this IFTTT, by adding another ConfiForms IFTTT macro (after the one which creates Jira issue) with action to "create/update ConfiForms entry" and parameters set to 

entryId=[entry.id]&JID=${iftttResult_JIRAID}

So, the result of the "Create Jira" action will be stored back to the record (in a form)

[Hagop H Bozawglanian]

Hello, I've looked into this and this only stores the result as a string and not as a Jira issue type. Is there a way to store the result as a Jira issue type?

[Alex Medved _ConfiForms_]

Yes, only the issue key is returned. And that is by design.

You can save the returned key back to ConfiForms field of "jira issue" type and access ANY property of the referenced Jira issue (including issue type, of course)

See details on available properties for each ConfiForms field type on https://wiki.vertuna.com/display/CONFIFORMS/Accessing+field+values+and+properties

[Hagop H Bozawglanian]

Thank you! 

I was able to save the key into a text field then use another IFTTT macro to pull the text and set the key to the "jira issue" field.

[Alex Medved _ConfiForms_]

There is no need to have a second IFTTT... just save the returned key into the ConfiForms Field of "Jira issue" type and use it to access any property of Jira issue directly

[Hagop H Bozawglanian]

If I don't use the second IFTTT I get this response:

${IFTTTRESULT_JI.KEY} - COM.ATLASSIAN.APPLINKS.INTERNAL.COMMON.AUTH.OAUTH.OAUTHMESSAGEPROBLEMEXCEPTION: OAUTH AUTHENTICATION FAILED: SIGNATURE_INVALID

[varatha]

I have also same requirement please help 

need to store issue back to confiform

[Alex Medved _ConfiForms_]

@varatha Answered you on many other tickets - see this example

[varatha]

Thanks for the reply

My Scenario:-

I have field approval status. Once approved and submit the form then Create Jira issue and save jira issue key store back into confiform.

But we are able to create "Jira issue" but could not store back Jirakey into confiform field.

but could not get Jira issue. Kindly help what i done wrong

[Alex Medved _ConfiForms_]

If you create a ticket in Jira conditionally, then this IFTTT that uses the result of a Jira Create issue IFTTT action should ALSO be conditional

How is your form is configured - could you share the complete configuration here (storage format is preferred)?

[varatha]

Sure i am try to send soon

Thanks for the quick reply

[varatha]

Hi

I could not find the View storage format option 

I have taken the screenshot of my page

Kindly let us know do you  need any more information.

[varatha]

[Alex Medved _ConfiForms_]

How the IFTTT to create Jira issue is configured?

[varatha]

{
    "fields": {
       "project":
       { 
          "key": "CITE"
       },
       "summary": "[entry.ProjectTitle]",
       "description": "\n\n- Demand Id: CITE-[entry.UniqueID]\n- Project Title: [entry.ProjectTitle]\n- Business Contact: [entry.BusinessContact]\n- System Interface Contact: [entry.SystemInterfaceContact]\n- Description: [entry.Description]\n\n Testing Timelines or Sprints: \n\n- Phase: [entry.Phase]\n- StartDate: [entry.StartDate]\n- EndDate: [entry.EndDate]\n- No. of Weeks: [entry.Numberofweeks]\n- UserRequirement: [entry.UserRequirement]\n- Comments: [entry.Comments]\n\n",
       "issuetype": {
          "name": "User Story"
           },
   },
     "customfield_10012": "EpicLink [entry.EpicLink]"
   
  }
 

[varatha]

Jira issue screenshot-2

Kindly let us know do you need any more information. Thanks

[Alex Medved _ConfiForms_]

So you have your IFTTT rule to create an issue in Jira to be executed onModified and only when the field "ApprovalStatus" has  certain value, but you configured an IFTTT that should take the result of it to be executed onCreated!?

[varatha]

  No, when modfied form create issue and store jira. Do i need change the event to OnModified? I tried that also.

[Alex Medved _ConfiForms_]

Well, if you want to use the result of that IFTTT then of course you need to run it with the same condition/event and place it after the IFTTT that produces the result

[varatha]

Hi Alex,

I have used the same event and condition but it does not work. Kindly help

[Alex Medved _ConfiForms_]

Do you have this IFTTT configured AFTER the one that creates the Jira issue?

Does you Jira issue creating IFTTT has a result name set to JIRAID?

May be this simple video will help (although I have tried to answer you earlier multiple times with links to tutorials and videos... kind of a last resort... but I will try - https://wiki.vertuna.com/download/attachments/178782502/Community%20-%20create%20Jira%20issue%20and%20save%20back%20created%20Jira%20issue%20key.mov?version=1&modificationDate=1736681997180&api=v2)

[varatha]

Hi Alex,

Excellent, Appreciated your help. It working now. 

But i got "Not option" message with key. Please find the screenshot. Please help.

[Alex Medved _ConfiForms_]

And how do you set the result from the IFTTT that creates a Jira issue? Looks like you set a value with a dollar sign or something

[varatha]

Yes You are right! Now its working properly. 

I really appreciate your help and Thanks alot for your great support. 

I have few other topics question. Please support that as well.

Once again Thank you. 

------------------------------------------------------------------

Now i have another query. Shall i ask here or post new question in the community forum?

[varatha]

Hi Alex.,

place it after the IFTTT that produces the result but its creating "Duplicate email"

If place IFFF out of the box existing IFFTT macro jira issue not creating,,

How do we resolve duplicate email. Please help.

[varatha]

I fixed myself. Used Stop propagation.

Thanks