Posted on

Sample

SELECT Name,AccountNumber,OwnerId,CreatedById,Id FROM Account WHERE Name!='2422' ORDER BY Id ASC LIMIT 10

{"fields":"Name,AccountNumber,OwnerId,CreatedById","o":"Account","by":"Id","filter":"Name!='2422'","n":"10","debug":"true"}

{"totalSize":10,"done":true,"records":[{"attributes":{"type":"Account","url":"\/services\/data\/v60.0\/sobjects\/Account\/0010K00001z4ZD3QAM"},"Name":"Marlenz","AccountNumber":null,"OwnerId":"00528000002UJUYAA4","CreatedById":"00528000002UJUYAA4","Id":"0010K00001z4ZD3QAM"},{"attributes":{"type":"Account","url":"\/services\/data\/v60.0\/sobjects\/Account\/0010K00001z4ZHeQAM"},"Name":"Kathy","AccountNumber":null,"OwnerId":"00528000002UJUYAA4","CreatedById":"00528000002UJUYAA4","Id":"0010K00001z4ZHeQAM"},{"attributes":{"type":"Account","url":"\/services\/data\/v60.0\/sobjects\/Account\/0010K00002ZE41uQAD"},"Name":"AD Company Inc","AccountNumber":null,"OwnerId":"00528000002UJUYAA4","CreatedById":"00528000002UJUYAA4","Id":"0010K00002ZE41uQAD"},{"attributes":{"type":"Account","url":"\/services\/data\/v60.0\/sobjects\/Account\/0010K00002bN4HoQAK"},"Name":"Ashley Inc. CDMX","AccountNumber":null,"OwnerId":"00528000002UJUYAA4","CreatedById":"00528000002UJUYAA4","Id":"0010K00002bN4HoQAK"},{"attributes":{"type":"Account","url":"\/services\/data\/v60.0\/sobjects\/Account\/0012800000KKPAPAA5"},"Name":"Edge Corp Inc","AccountNumber":"CD451796","OwnerId":"00528000002UJUYAA4","CreatedById":"00528000002UJUYAA4","Id":"0012800000KKPAPAA5"},{"attributes":{"type":"Account","url":"\/services\/data\/v60.0\/sobjects\/Account\/0012800000KKPAQAA5"},"Name":"Austin Textiles Corp","AccountNumber":"CD656092","OwnerId":"00528000002UJUYAA4","CreatedById":"00528000002UJUYAA4","Id":"0012800000KKPAQAA5"},{"attributes":{"type":"Account","url":"\/services\/data\/v60.0\/sobjects\/Account\/0012800000KKPARAA5"},"Name":"Tower Construction","AccountNumber":"CC213425","OwnerId":"00528000002UJUYAA4","CreatedById":"00528000002UJUYAA4","Id":"0012800000KKPARAA5"},{"attributes":{"type":"Account","url":"\/services\/data\/v60.0\/sobjects\/Account\/0012800000KKPASAA5"},"Name":"Dickenson plc","AccountNumber":"CC634267","OwnerId":"00528000002UJUYAA4","CreatedById":"00528000002UJUYAA4","Id":"0012800000KKPASAA5"},{"attributes":{"type":"Account","url":"\/services\/data\/v60.0\/sobjects\/Account\/0012800000KKPATAA5"},"Name":"Grand Hotels & Resorts","AccountNumber":"CD439877","OwnerId":"00528000002UJUYAA4","CreatedById":"00528000002UJUYAA4","Id":"0012800000KKPATAA5"},{"attributes":{"type":"Account","url":"\/services\/data\/v60.0\/sobjects\/Account\/0012800000KKPAUAA5"},"Name":"United Oil & Gas Corp.","AccountNumber":"CD355118","OwnerId":"00528000002UJUYAA4","CreatedById":"00528000002UJUYAA4","Id":"0012800000KKPAUAA5"}]}

{"objectName":"Account","fieldsArray":["Name","AccountNumber","OwnerId","CreatedById"],"currentLabelsArray":{"Id":"Account ID","IsDeleted":"Deleted","MasterRecordId":"Master Record ID","Name":"Account Name","Type":"Account Type","ParentId":"Parent Account ID","BillingStreet":"Billing Street","BillingCity":"Billing City","BillingState":"Billing State\/Province","BillingPostalCode":"Billing Zip\/Postal Code","BillingCountry":"Billing Country","BillingLatitude":"Billing Latitude","BillingLongitude":"Billing Longitude","BillingGeocodeAccuracy":"Billing Geocode Accuracy","BillingAddress":"Billing Address","ShippingStreet":"Shipping Street","ShippingCity":"Shipping City","ShippingState":"Shipping State\/Province","ShippingPostalCode":"Shipping Zip\/Postal Code","ShippingCountry":"Shipping Country","ShippingLatitude":"Shipping Latitude","ShippingLongitude":"Shipping Longitude","ShippingGeocodeAccuracy":"Shipping Geocode Accuracy","ShippingAddress":"Shipping Address","Phone":"Account Phone","Fax":"Account Fax","AccountNumber":"Account Number","Website":"Website","PhotoUrl":"Photo URL","Sic":"SIC Code","Industry":"Industry","AnnualRevenue":"Annual Revenue","NumberOfEmployees":"Employees","Ownership":"Ownership","TickerSymbol":"Ticker Symbol","Description":"Account Description","Rating":"Account Rating","Site":"Account Site","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","LastViewedDate":"Last Viewed Date","LastReferencedDate":"Last Referenced Date","IsPartner":"Partner Account","IsCustomerPortal":"Customer Portal Account","ChannelProgramName":"Channel Program Name","ChannelProgramLevelName":"Channel Program Level Name","Jigsaw":"Data.com Key","JigsawCompanyId":"Jigsaw Company ID","CleanStatus":"Clean Status","AccountSource":"Account Source","DunsNumber":"D-U-N-S Number","Tradestyle":"Tradestyle","NaicsCode":"NAICS Code","NaicsDesc":"NAICS Description","YearStarted":"Year Started","SicDesc":"SIC Description","DandbCompanyId":"D&B Company ID","CustomerPriority__c":"Customer Priority","SLA__c":"SLA","Active__c":"Active","NumberofLocations__c":"Number of Locations","UpsellOpportunity__c":"Upsell Opportunity","SLASerialNumber__c":"SLA Serial Number","SLAExpirationDate__c":"SLA Expiration Date","Customer_ID__c":"Customer ID","Count__c":"Count","URL__c":"URL","User_IDs__c":"User IDs","Text_User_ID__c":"User ID","Rich_Text__c":"Rich Text","Image__c":"Image","Image_Field__c":"Image Field","Formula__c":"Formula Field","WordPress_ID__c":"WordPress ID","Email__c":"Email","Email_Link__c":"Email Link","Business_Directory_Category__c":"Business Directory Category","UniqueID__c":"UniqueID"}}
Marlenz

Account Number


Owner ID

00528000002UJUYAA4

Created By ID

00528000002UJUYAA4
Kathy

Account Number


Owner ID

00528000002UJUYAA4

Created By ID

00528000002UJUYAA4
AD Company Inc

Account Number


Owner ID

00528000002UJUYAA4

Created By ID

00528000002UJUYAA4
Ashley Inc. CDMX

Account Number


Owner ID

00528000002UJUYAA4

Created By ID

00528000002UJUYAA4
Edge Corp Inc

Account Number

CD451796

Owner ID

00528000002UJUYAA4

Created By ID

00528000002UJUYAA4
Austin Textiles Corp

Account Number

CD656092

Owner ID

00528000002UJUYAA4

Created By ID

00528000002UJUYAA4
Tower Construction

Account Number

CC213425

Owner ID

00528000002UJUYAA4

Created By ID

00528000002UJUYAA4
Dickenson plc

Account Number

CC634267

Owner ID

00528000002UJUYAA4

Created By ID

00528000002UJUYAA4
Grand Hotels & Resorts

Account Number

CD439877

Owner ID

00528000002UJUYAA4

Created By ID

00528000002UJUYAA4
United Oil & Gas Corp.

Account Number

CD355118

Owner ID

00528000002UJUYAA4

Created By ID

00528000002UJUYAA4
Leave a Reply

Your email address will not be published. Required fields are marked *