Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I am pulling data from Workguru (our project management software) via API. All working ok however I cannot seem to get the data for a custom field.
This is the Swagger page Swagger UI (workguru.io) https://api.workguru.io/swagger/index.html
This one pulls the detail of the correct custom field https://api.workguru.io/api/services/app/CustomField/GetCustomFieldById?id=2199
However I cannot pull the value of that field in any of the projects.
I think this is the correct endpoint but unsure of the requirements for the description. /api/services/app/CustomField/GetCustomFieldValuesByTypeAndId
Any help would be appreciated - thanks
Solved! Go to Solution.
Hi @Anonymous ,
Base on your description, it seems like you're having trouble pulling the value of a custom field in Workguru via API: /api/services/app/CustomField/GetCustomFieldValuesByTypeAndId. To use this endpoint, you'll need to provide two parameters: 'customFieldTypeId' and 'entityId'. 'customFieldTypeId' refers to the ID of the custom field type you're trying to retrieve, you can get it from the returned detail of `/api/services/app/CustomField/GetCustomFieldById` endpoint. As for the `entityId`, you'll need to provide the ID of the project you're trying to retrieve the custom field value for. Once you have both of these parameters, you can make a GET request to the `/api/services/app/CustomField/GetCustomFieldValuesByTypeAndId` endpoint with the appropriate values and it should return the custom field value for that project.
Best Regards
Hi @Anonymous ,
Base on your description, it seems like you're having trouble pulling the value of a custom field in Workguru via API: /api/services/app/CustomField/GetCustomFieldValuesByTypeAndId. To use this endpoint, you'll need to provide two parameters: 'customFieldTypeId' and 'entityId'. 'customFieldTypeId' refers to the ID of the custom field type you're trying to retrieve, you can get it from the returned detail of `/api/services/app/CustomField/GetCustomFieldById` endpoint. As for the `entityId`, you'll need to provide the ID of the project you're trying to retrieve the custom field value for. Once you have both of these parameters, you can make a GET request to the `/api/services/app/CustomField/GetCustomFieldValuesByTypeAndId` endpoint with the appropriate values and it should return the custom field value for that project.
Best Regards
Great, thanks @Anonymous - appreciate the help.
Custom field ID is 2199 and an example project ID is 414125
I have tried this /api/services/app/CustomField/GetCustomFieldValuesByTypeAndId?customFieldTypeId=2199&entityid=414125 but pulling returns the following error
DataSource.Error: Web.Contents failed to get contents from 'https://api.workguru.io/api/services/app/CustomField/GetCustomFieldValuesByTypeAndId?customFieldTypeId=2199&entityid=414125' (500): Internal Server Error
Details:
DataSourceKind=Web
DataSourcePath=https://api.workguru.io/api/services/app/CustomField/GetCustomFieldValuesByTypeAndId
Url=https://api.workguru.io/api/services/app/CustomField/GetCustomFieldValuesByTypeAndId?customFieldTypeId=2199&entityid=414125
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
5 | |
4 | |
4 | |
4 |