Debug Salesforce API call: read the full log entry for request and response details. There is an SOQL query included in this request.

HTTP method: GET

URL of API call to Salesforce: https://d1r000001esileas.my.salesforce.com/services/data/v42.0/query?q=SELECT+Name%2C+Id%2C+BillingStreet%2C+BillingAddress%2C+BillingCity%2C+BillingPostalCode%2C+LastModifiedDate%2C+CreatedDate+FROM+Account+WHERE+RecordTypeId+IN+%28%270121r000000mRRNAA2%27%29+AND+LastModifiedDate+%3E+2022-06-28T09%3A18%3A33Z+ORDER+BY+LastModifiedDate+ASC+LIMIT+25

SOQL query that was sent to Salesforce

SELECT Name, Id, BillingStreet, BillingAddress, BillingCity, BillingPostalCode, LastModifiedDate, CreatedDate FROM Account WHERE RecordTypeId IN ('0121r000000mRRNAA2') AND LastModifiedDate > 2022-06-28T09:18:33Z ORDER BY LastModifiedDate ASC LIMIT 25

API result from Salesforce

Array
(
[code] => 200
[data] => Array
(
[totalSize] => 14
[done] => 1
[records] => Array
(
[0] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v42.0/sobjects/Account/0015I000002fGTwQAM
)

[Name] => Hong Kong
[Id] => 0015I000002fGTwQAM
[BillingStreet] => Room 1703 Ngan Chun House,Tung Chun Court
[BillingAddress] => Array
(
[city] => Shau Kei Wan
[country] => HONG KONG
[geocodeAccuracy] =>
[latitude] =>
[longitude] =>
[postalCode] => 999077
[state] =>
[street] => Room 1703 Ngan Chun House,Tung Chun Court
)

[BillingCity] => Shau Kei Wan
[BillingPostalCode] => 999077
[LastModifiedDate] => 2022-07-06T22:00:34.000+0000
[CreatedDate] => 2020-02-07T19:24:48.000+0000
)

[1] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v42.0/sobjects/Account/0015I000002fGWWQA2
)

[Name] => Hull Royal Infirmary
[Id] => 0015I000002fGWWQA2
[BillingStreet] => Dept.of Paediatrics,Hull Royal Infirmary
[BillingAddress] => Array
(
[city] => Anlab Rd. Hull
[country] =>
[geocodeAccuracy] =>
[latitude] =>
[longitude] =>
[postalCode] => HU3 2JZ
[state] =>
[street] => Dept.of Paediatrics,Hull Royal Infirmary
)

[BillingCity] => Anlab Rd. Hull
[BillingPostalCode] => HU3 2JZ
[LastModifiedDate] => 2022-07-06T22:00:34.000+0000
[CreatedDate] => 2020-02-07T19:24:51.000+0000
)

[2] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v42.0/sobjects/Account/0015I000002fHBYQA2
)

[Name] => Queens Hospital
[Id] => 0015I000002fHBYQA2
[BillingStreet] => Flat 1 Apollo House,Garrison Road
[BillingAddress] => Array
(
[city] => London
[country] =>
[geocodeAccuracy] =>
[latitude] =>
[longitude] =>
[postalCode] => E3 2FF
[state] =>
[street] => Flat 1 Apollo House,Garrison Road
)

[BillingCity] => London
[BillingPostalCode] => E3 2FF
[LastModifiedDate] => 2022-07-06T22:00:38.000+0000
[CreatedDate] => 2020-02-07T19:25:37.000+0000
)

[3] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v42.0/sobjects/Account/0015I000002fHD1QAM
)

[Name] => Radboud UMC
[Id] => 0015I000002fHD1QAM
[BillingStreet] => Vossenlaan 239,
[BillingAddress] => Array
(
[city] => Nijmegen
[country] => NETHERLANDS
[geocodeAccuracy] =>
[latitude] =>
[longitude] =>
[postalCode] => 6531SJ
[state] =>
[street] => Vossenlaan 239,
)

[BillingCity] => Nijmegen
[BillingPostalCode] => 6531SJ
[LastModifiedDate] => 2022-07-06T22:00:38.000+0000
[CreatedDate] => 2020-02-07T19:25:37.000+0000
)

[4] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v42.0/sobjects/Account/0015I000002fHQpQAM
)

[Name] => Southend University Hospital
[Id] => 0015I000002fHQpQAM
[BillingStreet] => 96 Burges Road,Thorpe Bay
[BillingAddress] => Array
(
[city] => Southend on Sea Essex
[country] =>
[geocodeAccuracy] =>
[latitude] =>
[longitude] =>
[postalCode] => SS1 3JJ
[state] =>
[street] => 96 Burges Road,Thorpe Bay
)

[BillingCity] => Southend on Sea Essex
[BillingPostalCode] => SS1 3JJ
[LastModifiedDate] => 2022-07-06T22:00:39.000+0000
[CreatedDate] => 2020-02-07T19:25:50.000+0000
)

[5] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v42.0/sobjects/Account/0015I000002fFhGQAU
)

[Name] => Amsterdam UMC
[Id] => 0015I000002fFhGQAU
[BillingStreet] => Brouwersgracht 182D,Amsterdam
[BillingAddress] => Array
(
[city] =>
[country] => NETHERLANDS
[geocodeAccuracy] =>
[latitude] =>
[longitude] =>
[postalCode] => 1013 HC
[state] =>
[street] => Brouwersgracht 182D,Amsterdam
)

[BillingCity] =>
[BillingPostalCode] => 1013 HC
[LastModifiedDate] => 2022-07-08T22:00:15.000+0000
[CreatedDate] => 2020-02-07T19:23:56.000+0000
)

[6] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v42.0/sobjects/Account/0015I000002fGKiQAM
)

[Name] => Good Hope Hospital
[Id] => 0015I000002fGKiQAM
[BillingStreet] => 82 Norman Rd,Parkhall
[BillingAddress] => Array
(
[city] => Walsall
[country] =>
[geocodeAccuracy] =>
[latitude] =>
[longitude] =>
[postalCode] => WS5 3QN
[state] =>
[street] => 82 Norman Rd,Parkhall
)

[BillingCity] => Walsall
[BillingPostalCode] => WS5 3QN
[LastModifiedDate] => 2022-07-08T22:00:19.000+0000
[CreatedDate] => 2020-02-07T19:24:37.000+0000
)

[7] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v42.0/sobjects/Account/0015I000002fHHEQA2
)

[Name] => Royal Brompton Hospital London
[Id] => 0015I000002fHHEQA2
[BillingStreet] => 29 Island Centre Way,Enfield
[BillingAddress] => Array
(
[city] => Middlesex
[country] =>
[geocodeAccuracy] =>
[latitude] =>
[longitude] =>
[postalCode] => EN3 6GS
[state] =>
[street] => 29 Island Centre Way,Enfield
)

[BillingCity] => Middlesex
[BillingPostalCode] => EN3 6GS
[LastModifiedDate] => 2022-07-08T22:00:23.000+0000
[CreatedDate] => 2020-02-07T19:25:40.000+0000
)

[8] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v42.0/sobjects/Account/0015I000002fGiSQAU
)

[Name] => Lister Hospital
[Id] => 0015I000002fGiSQAU
[BillingStreet] => 68 Ripon Road,Stevenage
[BillingAddress] => Array
(
[city] => Herts.
[country] =>
[geocodeAccuracy] =>
[latitude] =>
[longitude] =>
[postalCode] => SG1 4NB
[state] =>
[street] => 68 Ripon Road,Stevenage
)

[BillingCity] => Herts.
[BillingPostalCode] => SG1 4NB
[LastModifiedDate] => 2022-07-09T22:00:38.000+0000
[CreatedDate] => 2020-02-07T19:25:01.000+0000
)

[9] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v42.0/sobjects/Account/0015I000002fH8gQAE
)

[Name] => Private Practice
[Id] => 0015I000002fH8gQAE
[BillingStreet] => 98 Miltonos Street,Limassol
[BillingAddress] => Array
(
[city] =>
[country] => CYPRUS
[geocodeAccuracy] =>
[latitude] =>
[longitude] =>
[postalCode] => 3047
[state] =>
[street] => 98 Miltonos Street,Limassol
)

[BillingCity] =>
[BillingPostalCode] => 3047
[LastModifiedDate] => 2022-07-09T22:00:40.000+0000
[CreatedDate] => 2020-02-07T19:25:33.000+0000
)

[10] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v42.0/sobjects/Account/0015I000002fHHPQA2
)

[Name] => Royal Cornwall Hospital
[Id] => 0015I000002fHHPQA2
[BillingStreet] => Pendragon House,Royal Cornwall Hospital
[BillingAddress] => Array
(
[city] => Truro
[country] =>
[geocodeAccuracy] =>
[latitude] =>
[longitude] =>
[postalCode] => TR1
[state] =>
[street] => Pendragon House,Royal Cornwall Hospital
)

[BillingCity] => Truro
[BillingPostalCode] => TR1
[LastModifiedDate] => 2022-07-09T22:00:41.000+0000
[CreatedDate] => 2020-02-07T19:25:40.000+0000
)

[11] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v42.0/sobjects/Account/0015I000002fHx2QAE
)

[Name] => Wexham Park Hospital
[Id] => 0015I000002fHx2QAE
[BillingStreet] => 13 Norgrove Park,Gerrards Cross
[BillingAddress] => Array
(
[city] => Bucks
[country] =>
[geocodeAccuracy] =>
[latitude] =>
[longitude] =>
[postalCode] => Sl8 8QT
[state] =>
[street] => 13 Norgrove Park,Gerrards Cross
)

[BillingCity] => Bucks
[BillingPostalCode] => Sl8 8QT
[LastModifiedDate] => 2022-07-12T22:00:41.000+0000
[CreatedDate] => 2020-02-07T19:26:23.000+0000
)

[12] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v42.0/sobjects/Account/0015I000002fHHWQA2
)

[Name] => Royal Devon & Exeter Foundation Trust
[Id] => 0015I000002fHHWQA2
[BillingStreet] => Whitley House,Whitley
[BillingAddress] => Array
(
[city] => Melksham Wilts
[country] =>
[geocodeAccuracy] =>
[latitude] =>
[longitude] =>
[postalCode] => SN12 8QG
[state] =>
[street] => Whitley House,Whitley
)

[BillingCity] => Melksham Wilts
[BillingPostalCode] => SN12 8QG
[LastModifiedDate] => 2022-07-15T22:00:47.000+0000
[CreatedDate] => 2020-02-07T19:25:40.000+0000
)

[13] => Array
(
[attributes] => Array
(
[type] => Account
[url] => /services/data/v42.0/sobjects/Account/0015I000002fH4mQAE
)

[Name] => Peace Children’s Centre Watford
[Id] => 0015I000002fH4mQAE
[BillingStreet] => Peace Children’s Centre,Peace Prospect
[BillingAddress] => Array
(
[city] => Watford Herts
[country] =>
[geocodeAccuracy] =>
[latitude] =>
[longitude] =>
[postalCode] => WD17 3EW
[state] =>
[street] => Peace Children’s Centre,Peace Prospect
)

[BillingCity] => Watford Herts
[BillingPostalCode] => WD17 3EW
[LastModifiedDate] => 2022-07-17T22:00:39.000+0000
[CreatedDate] => 2020-02-07T19:25:27.000+0000
)

)

)

[from_cache] =>
[cached] =>
[is_redo] =>
)