SELECT Name,Amount,Id FROM Opportunity WHERE CloseDate < NEXT_YEAR ORDER BY Id ASC LIMIT 10
{"fields":"Name,Amount","o":"Opportunity","filter":"CloseDate < NEXT_YEAR","by":"Id","n":"10","debug":"true"}
{"totalSize":10,"done":true,"records":[{"attributes":{"type":"Opportunity","url":"\/services\/data\/v60.0\/sobjects\/Opportunity\/00628000007jfj9AAA"},"Name":"Susan Pooley","Amount":3619367,"Id":"00628000007jfj9AAA"},{"attributes":{"type":"Opportunity","url":"\/services\/data\/v60.0\/sobjects\/Opportunity\/00628000007jfjAAAQ"},"Name":"Christina Watson","Amount":2413260,"Id":"00628000007jfjAAAQ"},{"attributes":{"type":"Opportunity","url":"\/services\/data\/v60.0\/sobjects\/Opportunity\/00628000007jfjBAAQ"},"Name":"Lauren Campbell","Amount":25755842,"Id":"00628000007jfjBAAQ"},{"attributes":{"type":"Opportunity","url":"\/services\/data\/v60.0\/sobjects\/Opportunity\/00628000007jfjCAAQ"},"Name":"GenePoint Standby Generator","Amount":9150057,"Id":"00628000007jfjCAAQ"},{"attributes":{"type":"Opportunity","url":"\/services\/data\/v60.0\/sobjects\/Opportunity\/00628000007jfjDAAQ"},"Name":"Grand Hotels Kitchen Generator","Amount":11461270,"Id":"00628000007jfjDAAQ"},{"attributes":{"type":"Opportunity","url":"\/services\/data\/v60.0\/sobjects\/Opportunity\/00628000007jfjEAAQ"},"Name":"United Oil Refinery Generators","Amount":3844410,"Id":"00628000007jfjEAAQ"},{"attributes":{"type":"Opportunity","url":"\/services\/data\/v60.0\/sobjects\/Opportunity\/00628000007jfjFAAQ"},"Name":"United Oil SLA","Amount":17738687,"Id":"00628000007jfjFAAQ"},{"attributes":{"type":"Opportunity","url":"\/services\/data\/v60.0\/sobjects\/Opportunity\/00628000007jfjGAAQ"},"Name":"Grand Hotels Guest Portable Generators","Amount":3626699,"Id":"00628000007jfjGAAQ"},{"attributes":{"type":"Opportunity","url":"\/services\/data\/v60.0\/sobjects\/Opportunity\/00628000007jfjIAAQ"},"Name":"University of AZ Portable Generators","Amount":19728542,"Id":"00628000007jfjIAAQ"},{"attributes":{"type":"Opportunity","url":"\/services\/data\/v60.0\/sobjects\/Opportunity\/00628000007jfjJAAQ"},"Name":"Pyramid Emergency Generators","Amount":12040268,"Id":"00628000007jfjJAAQ"}]}
{"objectName":"Opportunity","fieldsArray":["Name","Amount"],"currentLabelsArray":{"Id":"Opportunity ID","IsDeleted":"Deleted","AccountId":"Account ID","IsPrivate":"Private","Name":"Name","Description":"Description","StageName":"Stage","Amount":"Amount","Probability":"Probability (%)","ExpectedRevenue":"Expected Amount","TotalOpportunityQuantity":"Quantity","CloseDate":"Close Date","Type":"Opportunity Type","NextStep":"Next Step","LeadSource":"Lead Source","IsClosed":"Closed","IsWon":"Won","ForecastCategory":"Forecast Category","ForecastCategoryName":"Forecast Category","CampaignId":"Campaign ID","HasOpportunityLineItem":"Has Line Item","Pricebook2Id":"Price Book ID","OwnerId":"Owner ID","CreatedDate":"Created Date","CreatedById":"Created By ID","LastModifiedDate":"Last Modified Date","LastModifiedById":"Last Modified By ID","SystemModstamp":"System Modstamp","LastActivityDate":"Last Activity","PushCount":"Push Count","LastStageChangeDate":"Last Stage Change Date","FiscalQuarter":"Fiscal Quarter","FiscalYear":"Fiscal Year","Fiscal":"Fiscal Period","ContactId":"Contact ID","LastViewedDate":"Last Viewed Date","LastReferencedDate":"Last Referenced Date","HasOpenActivity":"Has Open Activity","HasOverdueTask":"Has Overdue Task","LastAmountChangedHistoryId":"Opportunity History ID","LastCloseDateChangedHistoryId":"Opportunity History ID","DeliveryInstallationStatus__c":"Delivery\/Installation Status","TrackingNumber__c":"Tracking Number","OrderNumber__c":"Order Number","CurrentGenerators__c":"Current Generator(s)","MainCompetitors__c":"Main Competitor(s)","Anniversary_Date__c":"Anniversary Date","Anniversary_Dates__c":"Anniversary Dates","Date_and_Time__c":"Date and Time","End_Date_Time__c":"End Date Time","End_Date__c":"End Date","Difference__c":"Difference","Youtube__c":"Youtube Link","Photo__c":"Profile Photo","WordPress_ID__c":"WordPress ID","Bio__c":"Bio","Formatted_Bio__c":"Formatted Bio","Artist_Bio__c":"Artist_Bio","PatientName__c":"Patient Name","Website__c":"Website","Videos__c":"Videos","User_IDs__c":"User IDs","Detail_Link__c":"Detail Link","Formula_Field__c":"Formula Field","Sample_Date__c":"Sample Date","Contact_ID__c":"Contact ID","Close_Date_Format__c":"Close Date Format","Date_and_Time_TEXT__c":"Date and Time TEXT"}}
Susan Pooley
Amount
3619367Christina Watson
Amount
2413260Lauren Campbell
Amount
25755842GenePoint Standby Generator
Amount
9150057Grand Hotels Kitchen Generator
Amount
11461270United Oil Refinery Generators
Amount
3844410United Oil SLA
Amount
17738687Grand Hotels Guest Portable Generators
Amount
3626699University of AZ Portable Generators
Amount
19728542Pyramid Emergency Generators
Amount
12040268