Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

odata uri help

I have a large report to monitor actuals in Project Online timesheets and MS Project data. Due to the various joins required in the tables to provide the information I need to visualise in the report...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi Anonymous,

     

    These two articles could help. odata-filter-tips-tricks and odata-version-2-0/uri-conventions.

    It seems the Boolean type are treated as true and false, but not as strings. You can try this one:

    https://<tenantname>.sharepoint.com/sites/pwa/_api/projectdata/Resources?$select=ResourceId,ResourceName&$filter=ResourceIsGeneric eq false and ResourceIsActive eq true and Role ne 'Ex-RD' and Role ne 'NPI' and TypeName eq 'Work Resource'

    Best Regards!

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

 

These two articles could help. odata-filter-tips-tricks and odata-version-2-0/uri-conventions.

It seems the Boolean type are treated as true and false, but not as strings. You can try this one:

https://<tenantname>.sharepoint.com/sites/pwa/_api/projectdata/Resources?$select=ResourceId,ResourceName&$filter=ResourceIsGeneric eq false and ResourceIsActive eq true and Role ne 'Ex-RD' and Role ne 'NPI' and TypeName eq 'Work Resource'

Best Regards!

Dale