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-04T04%3A58%3A02Z+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-04T04:58:02Z ORDER BY LastModifiedDate ASC LIMIT 25
API result from Salesforce
(
[code] => 200
[data] => Array
(
[totalSize] => 2
[done] => 1
[records] => Array
(
[0] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v49.0/sobjects/Account/001f400000CPSu1AAH
)
[Stripe_Customer_Id__c] => cus_6a1IHwGYWj0jWE
[FirstName] => Don
[LastName] => Franzluebbers
[Primary_Email__c] => ldfranz@hotmail.com
[Wordpress_Id__c] => 1632
[Verified__c] =>
[PersonEmail] => ldfranz@hotmail.com
[No_Daily__c] => 1
[No_Weekly__c] =>
[No_Plus__c] =>
[No_LATAM__c] =>
[No_Climate__c] =>
[Phone] =>
[Company__c] =>
[Parent_Stripe__c] =>
[PC_Farm__c] =>
[Id] => 001f400000CPSu1AAH
[LastModifiedDate] => 2023-03-04T04:58:03.000+0000
[CreatedDate] => 2017-12-09T18:35:12.000+0000
)
[1] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v49.0/sobjects/Account/001f400000CPSbqAAH
)
[Stripe_Customer_Id__c] => cus_6a0ifX8VNR3LA1
[FirstName] => Michael
[LastName] => Fox
[Primary_Email__c] => mike.t.fox@gmail.com
[Wordpress_Id__c] => 972
[Verified__c] =>
[PersonEmail] => mike.t.fox@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] => 001f400000CPSbqAAH
[LastModifiedDate] => 2023-03-04T05:00:08.000+0000
[CreatedDate] => 2017-12-09T18:35:04.000+0000
)
)
)
[from_cache] =>
[cached] =>
[is_redo] =>
)
