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-13T12%3A40%3A32Z+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-13T12:40:32Z ORDER BY LastModifiedDate ASC LIMIT 25
API result from Salesforce
(
[code] => 200
[data] => Array
(
[totalSize] => 4
[done] => 1
[records] => Array
(
[0] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v49.0/sobjects/Account/0015G00001nt3NWQAY
)
[Stripe_Customer_Id__c] => cus_KP5gCqlS4wo9qY
[FirstName] => Steve
[LastName] => Liston
[Primary_Email__c] => steveliston80@gmail.com
[Wordpress_Id__c] => 1001414
[Verified__c] =>
[PersonEmail] => steveliston80@gmail.com
[No_Daily__c] => 1
[No_Weekly__c] =>
[No_Plus__c] => 1
[No_LATAM__c] =>
[No_Climate__c] =>
[Phone] => 5159432929
[Company__c] => Liston Farms LLC
[Parent_Stripe__c] =>
[PC_Farm__c] =>
[Id] => 0015G00001nt3NWQAY
[LastModifiedDate] => 2023-03-13T12:41:04.000+0000
[CreatedDate] => 2021-10-14T00:08:43.000+0000
)
[1] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v49.0/sobjects/Account/0015G00001cCL2kQAG
)
[Stripe_Customer_Id__c] =>
[FirstName] => Gary
[LastName] => gluginbill@pandoragrain.com
[Primary_Email__c] => gluginbill@pandoragrain.com
[Wordpress_Id__c] => 1001007
[Verified__c] =>
[PersonEmail] => gluginbill@pandoragrain.com
[No_Daily__c] => 1
[No_Weekly__c] =>
[No_Plus__c] => 1
[No_LATAM__c] =>
[No_Climate__c] =>
[Phone] =>
[Company__c] => Pandora Grain & Supply
[Parent_Stripe__c] =>
[PC_Farm__c] =>
[Id] => 0015G00001cCL2kQAG
[LastModifiedDate] => 2023-03-13T12:42:08.000+0000
[CreatedDate] => 2021-04-23T16:47:47.000+0000
)
[2] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v49.0/sobjects/Account/001f400000CPSazAAH
)
[Stripe_Customer_Id__c] => cus_6k1eGSTT4pj2eD
[FirstName] => Kevin
[LastName] => Phillips
[Primary_Email__c] => pggrain2010@gmail.com
[Wordpress_Id__c] => 917
[Verified__c] =>
[PersonEmail] => pggrain2010@gmail.com
[No_Daily__c] => 1
[No_Weekly__c] =>
[No_Plus__c] => 1
[No_LATAM__c] =>
[No_Climate__c] =>
[Phone] =>
[Company__c] =>
[Parent_Stripe__c] =>
[PC_Farm__c] =>
[Id] => 001f400000CPSazAAH
[LastModifiedDate] => 2023-03-13T12:42:08.000+0000
[CreatedDate] => 2017-12-09T18:35:04.000+0000
)
[3] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v49.0/sobjects/Account/001f400000HGsUIAA1
)
[Stripe_Customer_Id__c] => cus_CXY9goFedDasmY
[FirstName] => Brock
[LastName] => Schmitt
[Primary_Email__c] => brocknschmitt@gmail.com
[Wordpress_Id__c] => 4265
[Verified__c] => 1
[PersonEmail] => brocknschmitt@gmail.com
[No_Daily__c] => 1
[No_Weekly__c] =>
[No_Plus__c] =>
[No_LATAM__c] =>
[No_Climate__c] =>
[Phone] => 3098839735
[Company__c] =>
[Parent_Stripe__c] =>
[PC_Farm__c] =>
[Id] => 001f400000HGsUIAA1
[LastModifiedDate] => 2023-03-13T12:42:28.000+0000
[CreatedDate] => 2018-03-22T13:01:34.000+0000
)
)
)
[from_cache] =>
[cached] =>
[is_redo] =>
)
