Need to import Custom Field created by "HubSpot CRM Integration for Jira" plug-in

Questions & Answers
, ,
1

Hi Community!

I am currently trying to import the “HubSpot Client” field which, as I understand, belongs to a plugin installed in Jira where the field value is specified from another tool.

I have tried to retrieve it from Advanced Settings but haven’t been able to bring it in any way. I contacted support and they couldn’t provide a solution.
There are fields with the value if they are searched as "HubSpot Client" Is Not EMPTY

This is what support told me.
Make sure that this field is used in Jira issue screen.
Then try adding "add additional advanced settings " for the field configuration screen in eazyBI import options where you add these lines - use the field name instead of “FIELD_NAME”

json_fields = [“FIELD_NAME”]
OR json_fields = [“CUSTOMFIELD_ID”]

Then use reimport all data feature to reimport data in the dimension

Has anyone worked with a field of this type before?

I am attaching some images.

image
image1639×268 11 KB

Thank you!

1 Like
2

Hi @RaulHerrera

This seems like a custom field from Assets:
Please find the documentation page on how to import assets custom fields for issues:

https://docs.eazybi.com/eazybi/data-import/data-from-jira/assets-custom-fields-for-issues#Assetscustomfieldsforissues-Assetcustomfields

Martins / eazyBI

3

Martin Vanags from EazyBi Support solved my problem.

We use this code into Advanced Settings and worked.

[jira.customfield_hubspotclient]
data_type = "string"
dimension = true
name = "HubSpot Client"
json_fields = ["customfield_NNNNN"]
javascript_code = '''
if(issue.fields.customfield_NNNNN){
    issue.fields.customfield_hubspotclient = issue.fields.customfield_10105.label;
  }
'''

After changing advanced settings, it is required to reimport all data as explained here:

https://docs.eazybi.com/eazybi/data-import/data-from-jira#DatafromJira-Re-importalldata

1 Like