Skip to main content

Hello,

 

I am new to MaintainX and I have been trying to do some integration with our system as it has been quickly adopted by many of our end users. I have had success with the API calls offered. Specifically, I am using the List Work Orders pulling into PowerBI. However, our team has added some custom labels and custom fields. We use a custom Work Type label instead of the built-in Work Type selection. How do I pull in these custom fields? 

Still wondering if this is possible.

Great question - If you are referring to the custom time types created outside of “Work”, “Inspection” and “Other”, those custom fields should be accessible through this query: https://help.getmaintainx.com/powerbi-integration/query-reference#individual-entries rather than the list work orders query. 

Great question - If you are referring to the custom time types created outside of “Work”, “Inspection” and “Other”, those custom fields should be accessible through this query: https://help.getmaintainx.com/powerbi-integration/query-reference#individual-entries rather than the list work orders query. 

Thank you ​@hopekelly! I believe this will work for my purposes, however, it does not appear to be pulling those custom fields. 

On our WO, as shown in these filters, have two ‘Work Type’ tags, one being the built-in and one being the custom property.

The default work type has the original 4 options,

whereas the custom property has much more specific options allowing for more granularity.

This is the field I was hoping to capture as it is a major metric that we track.

Hmm well I posted a reply a little over a day ago with screenshots. However, I don’t see it yet. However, thank you ​@hopekelly. This is very close to what I am looking for. While I do see the standard built-in Work Type that comes along with the Work Order pull (REACTIVE, PREVENTATIVE, OTHER) there is another Work Type that can be seen when selecting Filters on the WO page, that has about 10-15 options. The icon on the left is a label/tag unlike the normal Work Type icon. This one I have yet to find a way to pull in, as this category separates different departments, like Maintenance, Facilities, etc. If those custom fields are able to be queried, this would be huge. Even if not using the PowerBI (csv) API connection, I would be happy a basic HTTP API to gather this information. 

​@Mentor Thanks! I am wondering if those are our “Categories” module that has been renamed to “Work Type” in your organization because it looks very similar to our categories module. If that is the case, it should be possible to retrieve using this query: https://help.getmaintainx.com/powerbi-integration/query-reference#work-orders with this parameter: {"Categories", type text}

 

 

 

​@hopekelly thank you so much! I can’t believe I had been pulling it the entire time and not realizing. Now just to figure out how to get PowerBI to auto-refresh by passing the token as a parameter when published to the cloud. 😉 Don’t think it is supported at the moment, so I think I will have to come up with a workaround.

 

Thank you again for your help!

Reply


Terms & ConditionsCookie settings