Get Salesforce and Piwik fields placed on Jira issues based upon customer

[magnetic-2]

Here's our business need:

1. what tier and products a customer has (we have this data in Piwik)

2. Account type (this is from Salesforce)

3. Add account manager from Account field in Salesforce as a watcher on the Jira issue.

4. A notes section to add to the customer (could be on the right side of the issues for the customer or on the organization page in Jira for that customer).

We were looking into using scriptrunner or powerscripts to execute this, but is there a more simplistic app we can use? Was looking at Connector for Salesforce & Jira by ServiceRocket, to take care of #2, but we're looking for an app that will cover more then just that.

[Kristian Walker _Adaptavist_]

Hi Magnetic,

Thank you for your question.

I can confirm that with ScriptRunner with Jira Cloud that it is possible to write scripts which interact with external systems such as Piwik and Salesforce and you can see further information on how to do this in the Knowledge Base Article here which explains ways to understand how the external systems third party API's work.

You would then write a script configured as a Script Listener to run on the Issue Created or Issue Updated events and your script would then have some logic in it to fetch the data from the external systems and then to save this data into variables in the scripts which can then be used to update the fields that you require setting in Jira.

I can confirm we have the example in the documentation here which shows how to call Slack and is an example of calling an external API that you can use as a reference as well as the examples here which show how to set different field types on an issue.

Finally, I can confirm we have an example here which shows how to set different user fields as well as an example here that shows how to set watchers on an issue.

You will be able to use all of these examples as reference guides to help you to create the script that you require to achieve your requirement.

I hope this information helps.

Regards,

Kristian