Project Program Insights
projectProgramInsights Based on 26C
Look up Project Program Insights. Read-only.
The record key projectProgramInsightsUniqID is a generated hash. Take it from the record's links (rel self) in a GET response; never build it yourself.
- Operations
- GET (list)GET (one)
- Record key
projectProgramInsightsUniqID- Required on create
- no create on this resource
- At a glance
- 310 fields5 finders1 children2 file/large text fields
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/projectProgramInsights?fields=ACBudgetLaborCost,ACBudgetMargin,ACCurrentandOriginalBudgetCostVariancePercentage,ACDurationinDays,ACOriginalBudgetCost&limit=25&onlyData=true
{
"items": [
{
"ACBudgetLaborCost": 0,
"ACBudgetMargin": 0,
"ACCurrentandOriginalBudgetCostVariancePercentage": 0,
"ACDurationinDays": 0,
"ACOriginalBudgetCost": 0
}
],
"count": 25,
"hasMore": true,
"limit": 25,
"offset": 0
}Shapes and placeholders, not real data. Replace https://<your-pod> and the login with your own: this site never sees them. Based on Oracle's 26C REST specification.
Fields 310
| Attribute | Type | Use |
|---|---|---|
ACBudgetLaborCost | number | Read-onlySearchable |
ACBudgetMargin | number | Read-onlySearchable |
ACCurrentandOriginalBudgetCostVariancePercentage | number | Read-onlySearchable |
ACDurationinDays | number | Read-onlySearchable |
ACOriginalBudgetCost | number | Read-onlySearchable |
ACOriginalBudgetLaborEffortinHours | number | Read-onlySearchable |
ACOriginalBudgetandActualCostVariance | number | Read-onlySearchable |
ACOriginalBudgetandEACForecastCostVariance | number | Read-onlySearchable |
ACOriginalBudgetandEACForecastMarginVariance | number | Read-onlySearchable |
ACOriginalBudgetandEACForecastRevenueVariance | number | Read-onlySearchable |
ActualWorkPlanEffortinHours | number | Read-onlySearchable |
AmountToBill | number | Read-onlySearchable |
AsOfPeriodEndDate | date-time | Read-onlySearchable |
AsOfPeriodName | text | Read-onlySearchable |
AsOfPeriodStartDate | date-time | Read-onlySearchable |
AssessmentCode | text · max 30 | Read-onlySearchable |
AssessmentMeaning | text · max 80 | Read-onlySearchable |
AssignmentsEndingSoon | number | Read-onlySearchable |
AssignmentsReserved | number | Read-onlySearchable |
CostPerformanceIndex | number | Read-onlySearchable |
CreatedBy | text · max 64 | Read-onlySearchable |
CreationDate | date-time | Read-onlySearchable |
CurrencyCode | text | Read-onlySearchable |
Description | text · max 2000 | Read-onlySearchable |
EACBudgetCost | number | Read-onlySearchable |
EACBudgetLaborEffort | number | Read-onlySearchable |
EACBudgetRevenue | number | Read-onlySearchable |
EACCurrentandOriginalBudgetMarginVariance | number | Read-onlySearchable |
EACCurrentandOriginalBudgetRevenueVariance | number | Read-onlySearchable |
EACCurrentandPreviousForecastCostVariance | number | Read-onlySearchable |
EACCurrentandPreviousForecastLaborEffortVariance | number | Read-onlySearchable |
EACCurrentandPreviousForecastMarginVariance | number | Read-onlySearchable |
EACCurrentandPreviousForecastRevenueVariance | number | Read-onlySearchable |
EACForecastLaborCost | number | Read-onlySearchable |
EACForecastLaborEffort | number | Read-onlySearchable |
EACForecastLaborEffortVariancePercentage | number | Read-onlySearchable |
EACForecastMargin | number | Read-onlySearchable |
EACForecastRevenue | number | Read-onlySearchable |
EarnedValue | number | Read-onlySearchable |
EarnedValueCostVariance | number | Read-onlySearchable |
EarnedValueScheduleVariance | number | Read-onlySearchable |
EstimatetoCompleteCost | number | Read-onlySearchable |
EstimatetoCompleteLaborEffortinHours | number | Read-onlySearchable |
FinishDate | date | Read-onlySearchable |
ITDActualCapitalizableCost | number | Read-onlySearchable |
ITDActualCapitalizableCostPercentage | number | Read-onlySearchable |
ITDActualCapitalizableCostPercentagePrevValues | text · max 255 | Read-onlySearchable |
ITDActualCapitalizableCostPrevValues | text · max 255 | Read-onlySearchable |
ITDActualCost | number | Read-onlySearchable |
ITDActualCostPrevValues | text · max 255 | Read-onlySearchable |
ITDActualInvoiceAmount | number | Read-onlySearchable |
ITDActualLaborCost | number | Read-onlySearchable |
ITDActualLaborCostPrevValues | text · max 255 | Read-onlySearchable |
ITDActualLaborEffort | number | Read-onlySearchable |
ITDActualLaborEffortPrevValues | text · max 255 | Read-onlySearchable |
ITDActualMargin | number | Read-onlySearchable |
ITDActualMarginPercentage | number | Read-onlySearchable |
ITDActualMarginPercentagePrevValues | text · max 255 | Read-onlySearchable |
ITDActualMarginPrevValues | text · max 255 | Read-onlySearchable |
ITDActualNonbillableCost | number | Read-onlySearchable |
ITDActualNonbillableCostPercentage | number | Read-onlySearchable |
ITDActualNonbillableCostPercentagePrevValues | text · max 255 | Read-onlySearchable |
ITDActualNonbillableCostPrevValues | text · max 255 | Read-onlySearchable |
ITDActualNonbillableLaborEffortinHours | number | Read-onlySearchable |
ITDActualNonbillableLaborEffortinHoursPrevValues | text · max 255 | Read-onlySearchable |
ITDActualSpentCostPercentage | number | Read-onlySearchable |
ITDActualSpentCostPercentagePrevValues | text · max 255 | Read-onlySearchable |
ITDActualSpentLaborEffortPercentage | number | Read-onlySearchable |
ITDActualSpentLaborEffortPercentagePrevValues | text · max 255 | Read-onlySearchable |
ITDActualandCommittedCost | number | Read-onlySearchable |
ITDActualandCommittedCostPrevValues | text · max 255 | Read-onlySearchable |
ITDBudgetCost | number | Read-onlySearchable |
ITDBudgetCostPrevValues | text · max 255 | Read-onlySearchable |
ITDBudgetLaborCost | number | Read-onlySearchable |
ITDBudgetLaborCostPrevValues | text · max 255 | Read-onlySearchable |
ITDBudgetLaborEffort | number | Read-onlySearchable |
ITDBudgetLaborEffortPrevValues | text · max 255 | Read-onlySearchable |
ITDBudgetMargin | number | Read-onlySearchable |
ITDBudgetMarginPercentage | number | Read-onlySearchable |
ITDBudgetMarginPercentagePrevValues | text · max 255 | Read-onlySearchable |
ITDBudgetMarginPrevValues | text · max 255 | Read-onlySearchable |
ITDBudgetRevenue | number | Read-onlySearchable |
ITDBudgetRevenuePrevValues | text · max 255 | Read-onlySearchable |
ITDCommittedCost | number | Read-onlySearchable |
ITDCostVariance | number | Read-onlySearchable |
ITDCostVariancePercentage | number | Read-onlySearchable |
ITDCostVariancePercentagePrevValues | text · max 255 | Read-onlySearchable |
ITDCostVariancePrevValues | text · max 255 | Read-onlySearchable |
ITDDurationinDays | number | Read-onlySearchable |
ITDForecastCost | number | Read-onlySearchable |
ITDForecastCostPrevValues | text · max 255 | Read-onlySearchable |
ITDForecastCostVariance | number | Read-onlySearchable |
ITDForecastCostVariancePercentage | number | Read-onlySearchable |
ITDForecastCostVariancePercentagePrevValues | text · max 255 | Read-onlySearchable |
ITDForecastCostVariancePrevValues | text · max 255 | Read-onlySearchable |
ITDForecastLaborCost | number | Read-onlySearchable |
ITDForecastLaborCostPrevValues | text · max 255 | Read-onlySearchable |
ITDForecastLaborEffort | number | Read-onlySearchable |
ITDForecastLaborEffortPrevValues | text · max 255 | Read-onlySearchable |
ITDForecastLaborEffortVariancePercentage | number | Read-onlySearchable |
ITDForecastLaborEffortVariancePercentagePrevValues | text · max 255 | Read-onlySearchable |
ITDForecastMargin | number | Read-onlySearchable |
ITDForecastMarginPercentageVariance | number | Read-onlySearchable |
ITDForecastMarginPercentageVariancePrevValues | text · max 255 | Read-onlySearchable |
ITDForecastMarginPrevValues | text · max 255 | Read-onlySearchable |
ITDForecastMarginVariance | number | Read-onlySearchable |
ITDForecastMarginVariancePercentage | number | Read-onlySearchable |
ITDForecastMarginVariancePercentagePrevValues | text · max 255 | Read-onlySearchable |
ITDForecastMarginVariancePrevValues | text · max 255 | Read-onlySearchable |
ITDForecastRevenue | number | Read-onlySearchable |
ITDForecastRevenuePrevValues | text · max 255 | Read-onlySearchable |
ITDForecastRevenueVariance | number | Read-onlySearchable |
ITDForecastRevenueVariancePercentage | number | Read-onlySearchable |
ITDForecastRevenueVariancePercentagePrevValues | text · max 255 | Read-onlySearchable |
ITDForecastRevenueVariancePrevValues | text · max 255 | Read-onlySearchable |
ITDLaborEffortVariancePercentage | number | Read-onlySearchable |
ITDLaborEffortVariancePercentagePrevValues | text · max 255 | Read-onlySearchable |
ITDMarginPercentageVariance | number | Read-onlySearchable |
ITDMarginPercentageVariancePrevValues | text · max 255 | Read-onlySearchable |
ITDMarginVariance | number | Read-onlySearchable |
ITDMarginVariancePrevValues | text · max 255 | Read-onlySearchable |
ITDRevenue | number | Read-onlySearchable |
ITDRevenuePrevValues | text · max 255 | Read-onlySearchable |
ITDRevenueVariance | number | Read-onlySearchable |
ITDRevenueVariancePercentage | number | Read-onlySearchable |
ITDRevenueVariancePercentagePrevValues | text · max 255 | Read-onlySearchable |
ITDRevenueVariancePrevValues | text · max 255 | Read-onlySearchable |
Image | text | Read-only |
ImageId | number | Read-onlySearchable |
ImageName | text · max 240 | Read-onlySearchable |
IncludePerformanceMeasuresFlag | text · max 1 | Read-onlySearchable |
InvoicesAwaitingApproval | number | Read-onlySearchable |
LastRefreshedDate | date-time | Read-onlySearchable |
LastUpdateDate | date-time | Read-onlySearchable |
LastUpdatedBy | text · max 64 | Read-onlySearchable |
LineOfBusinessCode | text · max 30 | Read-onlySearchable |
LineOfBusinessMeaning | text · max 80 | Read-onlySearchable |
MilestonesAtRisk | number | Read-onlySearchable |
MilestonesDueSoon | number | Read-onlySearchable |
MilestonesPastDue | number | Read-onlySearchable |
MissingTimeCardsFiveWeeksOld | number | Read-onlySearchable |
MissingTimeCardsFourWeeksOld | number | Read-onlySearchable |
MissingTimeCardsOneWeekOld | number | Read-onlySearchable |
MissingTimeCardsThreeWeeksOld | number | Read-onlySearchable |
MissingTimeCardsTwoWeeksOld | number | Read-onlySearchable |
ObjectId | number | Read-onlySearchable |
ObjectName | text · max 240 | Read-onlySearchable |
ObjectNoteExistsFlag | text · max 1 | Read-onlySearchable |
ObjectNumber | text · max 25 | Read-onlySearchable |
ObjectParentId | number | Read-onlySearchable |
ObjectType | text · max 7 | Read-onlySearchable |
ObjectWatchListId | text · max 240 | Read-onlySearchable |
Objective | text · max 400 | Read-onlySearchable |
OwnerId | number | Read-onlySearchable |
OwnerName | text · max 240 | Read-onlySearchable |
OwningOrganizationId | number | Read-onlySearchable |
OwningOrganizationName | text · max 240 | Read-onlySearchable |
PTDActualCapitalizableCost | number | Read-onlySearchable |
PTDActualCapitalizableCostPercentage | number | Read-onlySearchable |
PTDActualCapitalizableCostPercentagePrevValues | text · max 255 | Read-onlySearchable |
PTDActualCapitalizableCostPrevValues | text · max 255 | Read-onlySearchable |
PTDActualCost | number | Read-onlySearchable |
PTDActualCostPrevValues | text · max 255 | Read-onlySearchable |
PTDActualLaborCost | number | Read-onlySearchable |
PTDActualLaborCostPrevValues | text · max 255 | Read-onlySearchable |
PTDActualLaborEffort | number | Read-onlySearchable |
PTDActualLaborEffortPrevValues | text · max 255 | Read-onlySearchable |
PTDActualMargin | number | Read-onlySearchable |
PTDActualMarginPercentage | number | Read-onlySearchable |
PTDActualMarginPercentagePrevValues | text · max 255 | Read-onlySearchable |
PTDActualMarginPrevValues | text · max 255 | Read-onlySearchable |
PTDActualNonbillableCost | number | Read-onlySearchable |
PTDActualNonbillableCostPercentage | number | Read-onlySearchable |
PTDActualNonbillableCostPercentagePrevValues | text · max 255 | Read-onlySearchable |
PTDActualNonbillableCostPrevValues | text · max 255 | Read-onlySearchable |
PTDActualNonbillableLaborEffortinHours | number | Read-onlySearchable |
PTDActualNonbillableLaborEffortinHoursPrevValues | text · max 255 | Read-onlySearchable |
PTDActualandCommittedCost | number | Read-onlySearchable |
PTDActualandCommittedCostPrevValues | text · max 255 | Read-onlySearchable |
PTDBudgetCost | number | Read-onlySearchable |
PTDBudgetCostPrevValues | text · max 255 | Read-onlySearchable |
PTDBudgetLaborCost | number | Read-onlySearchable |
PTDBudgetLaborCostPrevValues | text · max 255 | Read-onlySearchable |
PTDBudgetLaborEffort | number | Read-onlySearchable |
PTDBudgetLaborEffortPrevValues | text · max 255 | Read-onlySearchable |
PTDBudgetMargin | number | Read-onlySearchable |
PTDBudgetMarginPercentage | number | Read-onlySearchable |
PTDBudgetMarginPercentagePrevValues | text · max 255 | Read-onlySearchable |
PTDBudgetMarginPrevValues | text · max 255 | Read-onlySearchable |
PTDBudgetRevenue | number | Read-onlySearchable |
PTDBudgetRevenuePrevValues | text · max 255 | Read-onlySearchable |
PTDCommittedCost | number | Read-onlySearchable |
PTDCostVariance | number | Read-onlySearchable |
PTDCostVariancePercentage | number | Read-onlySearchable |
PTDCostVariancePercentagePrevValues | text · max 255 | Read-onlySearchable |
PTDCostVariancePrevValues | text · max 255 | Read-onlySearchable |
PTDForecastCost | number | Read-onlySearchable |
PTDForecastCostPrevValues | text · max 255 | Read-onlySearchable |
PTDForecastCostVariance | number | Read-onlySearchable |
PTDForecastCostVariancePercentage | number | Read-onlySearchable |
PTDForecastCostVariancePercentagePrevValues | text · max 255 | Read-onlySearchable |
PTDForecastCostVariancePrevValues | text · max 255 | Read-onlySearchable |
PTDForecastLaborCost | number | Read-onlySearchable |
PTDForecastLaborCostPrevValues | text · max 255 | Read-onlySearchable |
PTDForecastLaborEffort | number | Read-onlySearchable |
PTDForecastLaborEffortPrevValues | text · max 255 | Read-onlySearchable |
PTDForecastLaborEffortVariancePercentage | number | Read-onlySearchable |
PTDForecastLaborEffortVariancePercentagePrevValues | text · max 255 | Read-onlySearchable |
PTDForecastMargin | number | Read-onlySearchable |
PTDForecastMarginPercentageVariance | number | Read-onlySearchable |
PTDForecastMarginPercentageVariancePrevValues | text · max 255 | Read-onlySearchable |
PTDForecastMarginPrevValues | text · max 255 | Read-onlySearchable |
PTDForecastMarginVariance | number | Read-onlySearchable |
PTDForecastMarginVariancePercentage | number | Read-onlySearchable |
PTDForecastMarginVariancePercentagePrevValues | text · max 255 | Read-onlySearchable |
PTDForecastMarginVariancePrevValues | text · max 255 | Read-onlySearchable |
PTDForecastRevenue | number | Read-onlySearchable |
PTDForecastRevenuePrevValues | text · max 255 | Read-onlySearchable |
PTDForecastRevenueVariance | number | Read-onlySearchable |
PTDForecastRevenueVariancePercentage | number | Read-onlySearchable |
PTDForecastRevenueVariancePercentagePrevValues | text · max 255 | Read-onlySearchable |
PTDForecastRevenueVariancePrevValues | text · max 255 | Read-onlySearchable |
PTDLaborEffortVariancePercentage | number | Read-onlySearchable |
PTDLaborEffortVariancePercentagePrevValues | text · max 255 | Read-onlySearchable |
PTDMarginPercentageVariance | number | Read-onlySearchable |
PTDMarginPercentageVariancePrevValues | text · max 255 | Read-onlySearchable |
PTDMarginVariance | number | Read-onlySearchable |
PTDMarginVariancePrevValues | text · max 255 | Read-onlySearchable |
PTDRevenue | number | Read-onlySearchable |
PTDRevenuePrevValues | text · max 255 | Read-onlySearchable |
PTDRevenueVariance | number | Read-onlySearchable |
PTDRevenueVariancePercentage | number | Read-onlySearchable |
PTDRevenueVariancePercentagePrevValues | text · max 255 | Read-onlySearchable |
PTDRevenueVariancePrevValues | text · max 255 | Read-onlySearchable |
ParentProgramNumber | text · max 25 | Read-onlySearchable |
PersonImage | text | Read-only |
PersonImageId | number | Read-onlySearchable |
PlannedValue | number | Read-onlySearchable |
PreviousPeriodName | text · max 15 | Read-onlySearchable |
PreviousPeriodStartDate | date-time | Read-onlySearchable |
PriorPeriodName | text · max 15 | Read-onlySearchable |
PriorPeriodStartDate | date-time | Read-onlySearchable |
PriorityCode | text · max 30 | Read-onlySearchable |
PriorityMeaning | text · max 80 | Read-onlySearchable |
ProgramBudget | number | Read-onlySearchable |
ProgramBudgetCurrency | text · max 15 | Read-onlySearchable |
ProgramLevel | number | Read-onlySearchable |
ProjectCompletePercentage | number | Read-onlySearchable |
ProjectRelationshipId | number | Read-onlySearchable |
PublicFlag | text · max 1 | Read-onlySearchable |
RegionCode | text · max 30 | Read-onlySearchable |
RegionMeaning | text · max 80 | Read-onlySearchable |
SchedulePerformanceIndex | number | Read-onlySearchable |
StartDate | date | Read-onlySearchable |
StatusName | text · max 80 | Read-onlySearchable |
StrategyCode | text · max 30 | Read-onlySearchable |
StrategyMeaning | text · max 80 | Read-onlySearchable |
SystemStatusCode | text · max 30 | Read-onlySearchable |
TaskExceptionsCount | number | Read-onlySearchable |
TreeStructureId | number | Read-onlySearchable |
UnpaidInvoiceAmount | number | Read-onlySearchable |
UserAccess | text · max 30 | Read-onlySearchable |
UserAccessMeaning | text · max 80 | Read-onlySearchable |
WeekFiveToEightOverAllocated | number | Read-onlySearchable |
WeekFiveToEightUnderAllocated | number | Read-onlySearchable |
WeekNineToTwelveOverAllocated | number | Read-onlySearchable |
WeekNineToTwelveUnderAllocated | number | Read-onlySearchable |
WeekOneToFourOverAllocated | number | Read-onlySearchable |
WeekOneToFourUnderAllocated | number | Read-onlySearchable |
WorkPlanCompletePercentage | number | Read-onlySearchable |
WorkPlanScheduledEffortinHours | number | Read-onlySearchable |
YTDActualCapitalizableCost | number | Read-onlySearchable |
YTDActualCapitalizableCostPercentage | number | Read-onlySearchable |
YTDActualCost | number | Read-onlySearchable |
YTDActualLaborCost | number | Read-onlySearchable |
YTDActualLaborEffort | number | Read-onlySearchable |
YTDActualMargin | number | Read-onlySearchable |
YTDActualMarginPercentage | number | Read-onlySearchable |
YTDActualNonbillableCost | number | Read-onlySearchable |
YTDActualNonbillableCostPercentage | number | Read-onlySearchable |
YTDActualNonbillableLaborEffortinHours | number | Read-onlySearchable |
YTDActualandCommittedCost | number | Read-onlySearchable |
YTDBudgetCost | number | Read-onlySearchable |
YTDBudgetLaborCost | number | Read-onlySearchable |
YTDBudgetLaborEffort | number | Read-onlySearchable |
YTDBudgetMargin | number | Read-onlySearchable |
YTDBudgetMarginPercentage | number | Read-onlySearchable |
YTDBudgetRevenue | number | Read-onlySearchable |
YTDCommittedCost | number | Read-onlySearchable |
YTDCostVariance | number | Read-onlySearchable |
YTDCostVariancePercentage | number | Read-onlySearchable |
YTDForecastCost | number | Read-onlySearchable |
YTDForecastCostVariance | number | Read-onlySearchable |
YTDForecastCostVariancePercentage | number | Read-onlySearchable |
YTDForecastLaborCost | number | Read-onlySearchable |
YTDForecastLaborEffort | number | Read-onlySearchable |
YTDForecastLaborEffortVariancePercentage | number | Read-onlySearchable |
YTDForecastMargin | number | Read-onlySearchable |
YTDForecastMarginPercentageVariance | number | Read-onlySearchable |
YTDForecastMarginVariance | number | Read-onlySearchable |
YTDForecastMarginVariancePercentage | number | Read-onlySearchable |
YTDForecastRevenue | number | Read-onlySearchable |
YTDForecastRevenueVariance | number | Read-onlySearchable |
YTDForecastRevenueVariancePercentage | number | Read-onlySearchable |
YTDLaborEffortVariancePercentage | number | Read-onlySearchable |
YTDMarginPercentageVariance | number | Read-onlySearchable |
YTDMarginVariance | number | Read-onlySearchable |
YTDRevenue | number | Read-onlySearchable |
YTDRevenueVariance | number | Read-onlySearchable |
YTDRevenueVariancePercentage | number | Read-onlySearchable |
Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.
Finders 5
Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.
findByCurrencyCode·CurrencyCodeIncludePerformanceMeasuresFlagfindByIncludePerformanceMeasureFlag·IncludePerformanceMeasuresFlagfindByObjectType·ObjectTypefindByPeriodName·AsOfPeriodNameIncludePerformanceMeasuresFlagfindByProgramHierarchies·AncestorProgramIdAsOfPeriodNameCurrencyCodeIncludePerformanceMeasuresFlagObjectTypeProgramContextSearchKeyword
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Children 1
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/projectProgramInsights/{projectProgramInsightsUniqID}/child/<name>. Add them to a GET with expand.
ProgramDFFGET Program Descriptive Flexfields · 3 fieldsProjectProgramId__FLEX_Context__FLEX_Context_DisplayValue
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/projectProgramInsightsand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
findByCurrencyCodefor the agent's main search: its variables become clean tool parameters. - Narrow with
q=on searchable fields and a smalllimit; for a count usetotalResults=true&limit=1. - Call once and pass the result on to later steps rather than calling the same endpoint again.
More in For Builders.
Pitfalls
- Attribute names are case-sensitive in
q,fieldsand bodies:ACBudgetLaborCost, notacbudgetlaborcost. onlyData=trueremoveslinks, and this resource's key only comes fromlinks. Leave it off when you need the key.- Send dates as
YYYY-MM-DD; date-time fields take ISO 8601 with a time zone. - A list returns 25 rows unless you set
limit; readhasMoreand moveoffsetto page through.