How can I join the PMProject object with PMTasks? When I use the $expand paramater, I keep getting errors.
I have tried PMTask, Task and both are resulting in errors.
Best answer by abhijit
View originalHow can I join the PMProject object with PMTasks? When I use the $expand paramater, I keep getting errors.
I have tried PMTask, Task and both are resulting in errors.
Best answer by abhijit
View originalI was able to resolve this using these steps.
1) Download the metadata for acumatica. This metadata is always in XML format.
2) In the metadata search for EntityType Name="PMProject"
Once you’ve found this, you can start exploring the NavigationProperty under the Entity. You can only expand a navigation property if it is of type “collection”.
3) I looked for the collection property PMTaskCollection and PMBudgetCollection. These are the properties that I added to the $expand parameter. Now my call in Postman is returning the correct data.
Hi
I’m not very good on the JSON side of things, but Tasks don’t reside in the PMProject table. You will need to pull in PMTask, and join PMProject.ContractID with PMTask.ProjectID.
Good luck!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.