Is it possible to get organization details with EazyBi?

Questions & Answers
1

Hi EazyBI Team,

I’m trying to import a custom detail field from the Organization entity into EazyBI.

Each organization in our system represents a restaurant, and we’ve added a custom detail field called “Company” to indicate which company the restaurant belongs to.

I’d like to use this field in EazyBI reports, but I haven’t been able to find how to import or access it.

Could you guide me on how to make this field available in EazyBI?

Thanks a lot for your help!

Best regards,

2

Hi @valideo

Please share more details - what is the “Organization entity” in
Is this an Assets object?

if that is an asset object’s custom field, I would recommend reading this page on how to import asset custom fields from assets schema.

Please share more details.
Martins / eazyBI

3

Hi Martin,

Thanks for your reply !

To clarify, when I mention the “Organization” field, I’m referring to a default field that’s automatically created in Jira Service Management projects — the kind used for support. It’s a native and essential part of those project types.

This field is used to reference clients. In our case, we’ve set up each organization to represent one of our points of sale (which are restaurants).

On top of that, Jira allows us to link custom fields to each organization. For example, we’ve added a field called “Enseigne” to indicate which brand each restaurant belongs to.
We also have a field called ville (city in french)

So essentially, the organization field lets us know which client the request is coming from, and the additional custom fields help us filter or group data more precisely in reports.

I’ll also share a screenshot to make it clearer.

Here is where we create our organisations

Then we define the custom fields linked to the organization field here

And finally here’s how an organization uses it

I do not have the asset option as a data source.

Images here : Your connected workspace for wiki, docs & projects | Notion

Thanks for your help !

4

Thanks for sharing the images.

However, I can’t see the same feature to add custom fields to the organization on my Jira Service Management projects on the Cloud.
Is that some additional app you use to add these custom fields for organizations?
Do you use Jira Cloud or the Datacenter version?

Martins / eazyBI

5

Hi @martins.vanags,

No I’m not using an additional but I think you have to enable it : Manage organization detail fields | Jira Service Management Cloud | Atlassian Support

I’m using Jira Cloud

6

Thanks.
I was able to add the custom details to my organization.

Unfortunately, it is not possible to add additional data to Organization dimension members in eazyBI because Organization is imported from a multi-value custom field.
And even if there is just one organization per issue always, I couldn’t find any Rest API documentation on the Atlassian site on how to request the organization details.

Martins / eazyBI

7

Hi @martins.vanags,

Thanks, I understand now. I’ve already taken a look at the API documentation and I came across this:

Isn’t this what I’m referring to — the organization attributes?

Let me know if I’m misunderstanding something.

Thanks again!

8

The problem is that “organization” is a multi-value field in Jira.
For dimensions imported from multi-value fields you can not add additional attributes even if there is a Rest API endpoint.

The only workaround I could imagine is if you always use (100% times) just one organization per issue in Jira. In that case, we could take the first organization from the issue (assuming there is just one) and import in a new dimension, which would let you import additional properties from the rest api source applications.

Have you already tried the “get property” rest api endpoint to find these properties?

Martins / eazyBI