When working with data from OpenGround that contains pick list values it can be useful to bring back the descriptions for the items as well. This allows you to show "Rotary Cored" instead of "RC" within a report.
To bring back the pick list items you need to use the GetProjectPicklistValues command as shown in the example below.
The GetProjectPicklistValues has three parameters Cloud, ProjectInstance and PickListID.
Cloud: This is the Cloud ID that is used in many reports and usually set up as a report parameter.
ProjectInstance: This is the internal ID for the project. To find this parameter you must use the GetProjectInstanceIdentifier command as shown below
ProjectIdentifier = OpenGround.GetProjectInstanceIdentifier(Cloud, ProjectId),
PickListID: This is the internal ID for the picklist group. To find this parameter you must use the GetProjectPicklistHeaderGroups using the example below
LocationTypePicklistGroup = OpenGround.GetProjectPicklistHeaderGroups(Cloud, ProjectIdentifier, Group, Header),Results = Table.First(LocationTypePicklistGroup), PickListID = Results[Id],