VB Excel add-in: How to sort a Child Collection chronologically by Period
Summary:
Using the VB for Excel add-in. Created a Workbook with the following layouts:
- Financial Project Plans
- Resource Assignments
- Planning Amounts
- Planning Amount Details
- Planning Amounts
- Resource Assignments
How do I retrieve the Planning Amount Details results sorted by Period — chronologically, not alphabetical?
Content (please ensure you mask any confidential information):
I referenced the documentation on sort and this Support Document, added orderBy
to the Download parameters for the Planning Amount Details.
…PlanningAmountDetails?offset=0&limit=499&orderBy=Period:asc&links=self&fields=PeriodName,RawCost,ManualSpreadFlag
I keep getting the following error.
URL request parameter orderBy with value Period:asc is not valid.
AND, even if that worked, wouldn't it return with the collection sorted alphabetically? How would I get the results to sort chronologically?