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-09T18%3A12%3A38Z+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-09T18:12:38Z 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/001f400001JQMD0AAP
)
[Stripe_Customer_Id__c] => cus_K1m0vvlk66tqr8
[FirstName] => Thorsten
[LastName] => Tiedemann
[Primary_Email__c] => t.tiedemann@getreide-ag.de
[Wordpress_Id__c] => 1250
[Verified__c] =>
[PersonEmail] => t.tiedemann@getreide-ag.de
[No_Daily__c] => 1
[No_Weekly__c] =>
[No_Plus__c] => 1
[No_LATAM__c] =>
[No_Climate__c] =>
[Phone] => +49 171 86 666 11
[Company__c] =>
[Parent_Stripe__c] => cus_ExQQX0I5dhU8OL
[PC_Farm__c] =>
[Id] => 001f400001JQMD0AAP
[LastModifiedDate] => 2023-03-09T18:12:58.000+0000
[CreatedDate] => 2020-02-18T11:43:25.000+0000
)
[1] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v49.0/sobjects/Account/0015G00002EnxBhQAJ
)
[Stripe_Customer_Id__c] => cus_MdFCabRr7XzRu7
[FirstName] => Jacob
[LastName] => Kuntz
[Primary_Email__c] => jacob@kuntzbyproducts.com
[Wordpress_Id__c] => 1002080
[Verified__c] =>
[PersonEmail] => jacob@kuntzbyproducts.com
[No_Daily__c] => 1
[No_Weekly__c] =>
[No_Plus__c] =>
[No_LATAM__c] =>
[No_Climate__c] =>
[Phone] => 8154195981
[Company__c] => Kuntz By-Products
[Parent_Stripe__c] =>
[PC_Farm__c] =>
[Id] => 0015G00002EnxBhQAJ
[LastModifiedDate] => 2023-03-09T18:16:23.000+0000
[CreatedDate] => 2022-10-17T19:11:11.000+0000
)
)
)
[from_cache] =>
[cached] =>
[is_redo] =>
)
