We are trying to integrate Jira with Cherwell ticketing system ? Issues in mapping custom fields

[srinath]

Hi , we are trying to integrate JIRA with Cherwell ticketing system to raise service requests within our organization. I am able to integrate system fields but not able to integrate custom fields. Do we need to publish API's for JIRA custom fields? Please suggest if there is anything else we need to achieve the integration.
Also, may I know where in database are the custom fields stored such as table names,et

[Rab Garret]

Hi,

Here is a specific solution that will be applicable for your use case from a third party tool:

https://zigiwave.com/new-features-in-our-cherwell-integration/

Regards, Garret

[James Hainaut]

the custom fields can come across as "cusomtfield_12546" or something like that. I used Fidler or in Chrome browser, the f12 devTools. Then perform some actions in Jira that will result in displaying the data from your custom field. I created a dummy jira issue for this purpose and put data in the fields to make it easier to find.

here is an example of what I got:
{ "expand": "renderedFields,names,schema,operations,editmeta,changelog,versionedRepresentations", "id": "147019", "self": "https://XXXXXXX.jira.com/rest/api/2/issue/147019", "key": "TST-706", "fields": { "customfield_12546": "THis is the custom solution that I just typed in", "customfield_12543": [ { "self": "https://XXXXXXX.jira.com/rest/api/2/customFieldOption/10730", "value": "Application Problem", "id": "10730" } ], "status": { //status "self": "https://XXXXXXXX.jira.com/rest/api/2/status/6", "description": "This issue is considered finished (accepted by the customer) with nothing more left to do", "iconUrl": "https://XXXXXXX.jira.com/images/icons/statuses/closed.png", "name": "Closed", "id": "6", "statusCategory": { "self": "https://XXXXXXX.jira.com/rest/api/2/statuscategory/3", "id": 3, "key": "done", "colorName": "green", "name": "Done" } } }}

so in Cherwell, to ensure I get those fields, I have a "Get Jira Status" method defined in my Jira Web Service where I have the Endpoint as 'rest/api/2/issue/{issueKey}?fields=status,assignee,customfield_12543,customfield_12546' and a parameter of 'issueKey' (type=endpoint) that auto inserts into the curly braced token in the endpoint address.

[Nic Brough -Adaptavist-]

What do you mean by "integrate"?  What are you doing and where, in which application?

Stay away from the database, there be dragons (you'll be ok if you read them carefully, but any attempt to write will result in your data being charred to a crisp and noisily eaten)