HTTP method: GET
URL of API call to Salesforce: https://agresource.my.salesforce.com/services/data/v49.0/query?q=SELECT+Stripe_Customer_Id__c%2C+FirstName%2C+LastName%2C+Primary_Email__c%2C+Wordpress_Id__c%2C+Verified__c%2C+PersonEmail%2C+No_Daily__c%2C+No_Weekly__c%2C+No_Plus__c%2C+No_LATAM__c%2C+No_Climate__c%2C+Phone%2C+Company__c%2C+Parent_Stripe__c%2C+PC_Farm__c%2C+Id%2C+LastModifiedDate%2C+CreatedDate+FROM+Account+WHERE+RecordTypeId+IN+%28%27012f4000000sykaAAA%27%29+AND+LastModifiedDate+%3E+2023-03-03T14%3A56%3A04Z+ORDER+BY+LastModifiedDate+ASC+LIMIT+25
SOQL query that was sent to Salesforce
SELECT Stripe_Customer_Id__c, FirstName, LastName, Primary_Email__c, WordPress_Id__c, Verified__c, PersonEmail, No_Daily__c, No_Weekly__c, No_Plus__c, No_LATAM__c, No_Climate__c, Phone, Company__c, Parent_Stripe__c, PC_Farm__c, Id, LastModifiedDate, CreatedDate FROM Account WHERE RecordTypeId IN ('012f4000000sykaAAA') AND LastModifiedDate > 2023-03-03T14:56:04Z ORDER BY LastModifiedDate ASC LIMIT 25
API result from Salesforce
(
[code] => 200
[data] => Array
(
[totalSize] => 3
[done] => 1
[records] => Array
(
[0] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v49.0/sobjects/Account/001f40000105nL5AAI
)
[Stripe_Customer_Id__c] => cus_FBenzCs0089C0i
[FirstName] => Eric
[LastName] => Brown
[Primary_Email__c] => eric@lcadvisorsllc.com
[Wordpress_Id__c] => 1000277
[Verified__c] =>
[PersonEmail] => eric@lcadvisorsllc.com
[No_Daily__c] => 1
[No_Weekly__c] =>
[No_Plus__c] => 1
[No_LATAM__c] =>
[No_Climate__c] =>
[Phone] => (419)663-3892
[Company__c] => Legacy Capital Advisors, LLC
[Parent_Stripe__c] =>
[PC_Farm__c] =>
[Id] => 001f40000105nL5AAI
[LastModifiedDate] => 2023-03-03T14:56:06.000+0000
[CreatedDate] => 2019-06-03T14:50:08.000+0000
)
[1] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v49.0/sobjects/Account/001f400000CPSaNAAX
)
[Stripe_Customer_Id__c] => cus_6a0VAAxecqcaAi
[FirstName] => Clay
[LastName] => Scott
[Primary_Email__c] => westacre@pld.com
[Wordpress_Id__c] => 878
[Verified__c] =>
[PersonEmail] => westacre@pld.com
[No_Daily__c] => 1
[No_Weekly__c] =>
[No_Plus__c] => 1
[No_LATAM__c] =>
[No_Climate__c] =>
[Phone] => 6203561495
[Company__c] => west acres grain
[Parent_Stripe__c] =>
[PC_Farm__c] =>
[Id] => 001f400000CPSaNAAX
[LastModifiedDate] => 2023-03-03T14:56:12.000+0000
[CreatedDate] => 2017-12-09T18:35:04.000+0000
)
[2] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v49.0/sobjects/Account/001f400001A7xUjAAJ
)
[Stripe_Customer_Id__c] => cus_FcFIWclHwXMoY2
[FirstName] => chad
[LastName] => wells
[Primary_Email__c] => chad@annapolisgrainco.com
[Wordpress_Id__c] => 1000428
[Verified__c] =>
[PersonEmail] => chad@annapolisgrainco.com
[No_Daily__c] => 1
[No_Weekly__c] =>
[No_Plus__c] =>
[No_LATAM__c] =>
[No_Climate__c] =>
[Phone] => 618-562-3318
[Company__c] => annapolis grain co.
[Parent_Stripe__c] =>
[PC_Farm__c] =>
[Id] => 001f400001A7xUjAAJ
[LastModifiedDate] => 2023-03-03T14:58:25.000+0000
[CreatedDate] => 2019-08-13T14:17:03.000+0000
)
)
)
[from_cache] =>
[cached] =>
[is_redo] =>
)
