Search
Kids Hope Australia
Back to top

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://kidshope.my.salesforce.com/services/data/v55.0/query?q=SELECT+Email%2C+FirstName%2C+LastName%2C+Contact_Type__c%2C+npsp__Primary_Affiliation__c%2C+Full_Name__c%2C+Id%2C+LastModifiedDate%2C+CreatedDate+FROM+Contact+WHERE+%28++++Contact_Type__c+LIKE+%27%25Mentor%25%27++++OR+Contact_Type__c+LIKE+%27%25Coordinator%25%27++++OR+WP_User__c+%21%3D+null%29AND++LastModifiedDate+%3E+2026-02-11T12%3A02%3A35Z+ORDER+BY+LastModifiedDate+ASC+LIMIT+20+OFFSET+60

SOQL query that was sent to Salesforce

SELECT Email, FirstName, LastName, Contact_Type__c, npsp__Primary_Affiliation__c, Full_Name__c, Id, LastModifiedDate, CreatedDate FROM Contact WHERE (
Contact_Type__c LIKE '%Mentor%'
OR Contact_Type__c LIKE '%Coordinator%'
OR WP_User__c != null
)
AND LastModifiedDate > 2026-02-11T12:02:35Z ORDER BY LastModifiedDate ASC LIMIT 20 OFFSET 60

API result from Salesforce

Array
(
[code] => 200
[data] => Array
(
[totalSize] => 20
[done] => 1
[records] => Array
(
[0] => Array
(
[attributes] => Array
(
[type] => Contact
[url] => /services/data/v55.0/sobjects/Contact/003J1000001lCxyIAE
)

[Email] => mjmarie@hotmail.co.uk
[FirstName] => Marie Joyce
[LastName] => Marie
[Contact_Type__c] =>
[npsp__Primary_Affiliation__c] => 0015g00001V659xAAB
[Full_Name__c] => Marie Joyce Marie
[Id] => 003J1000001lCxyIAE
[LastModifiedDate] => 2026-02-11T12:30:57.000+0000
[CreatedDate] => 2024-05-28T06:52:39.000+0000
)

[1] => Array
(
[attributes] => Array
(
[type] => Contact
[url] => /services/data/v55.0/sobjects/Contact/003OZ00000HXkf3YAD
)

[Email] => mmd2@bigpond.com
[FirstName] => Michelle
[LastName] => Dalton Dobbie
[Contact_Type__c] => Coordinator;
[npsp__Primary_Affiliation__c] => 001OZ00000KdTcyYAF
[Full_Name__c] => Michelle Dalton Dobbie
[Id] => 003OZ00000HXkf3YAD
[LastModifiedDate] => 2026-02-11T12:30:57.000+0000
[CreatedDate] => 2025-02-05T06:26:14.000+0000
)

[2] => Array
(
[attributes] => Array
(
[type] => Contact
[url] => /services/data/v55.0/sobjects/Contact/003OZ00000HxbxrYAB
)

[Email] => mmorris701@gmail.com
[FirstName] => Michael
[LastName] => Morris
[Contact_Type__c] => Mentor;
[npsp__Primary_Affiliation__c] => 0015g00001NFz2YAAT
[Full_Name__c] => Michael Morris
[Id] => 003OZ00000HxbxrYAB
[LastModifiedDate] => 2026-02-11T12:35:21.000+0000
[CreatedDate] => 2025-02-16T09:46:10.000+0000
)

[3] => Array
(
[attributes] => Array
(
[type] => Contact
[url] => /services/data/v55.0/sobjects/Contact/0035g000012uoaUAAQ
)

[Email] => indrani.lewthwaite@gmail.com
[FirstName] => Indrani
[LastName] => Lewthwaite
[Contact_Type__c] => Coordinator; Mentor;
[npsp__Primary_Affiliation__c] => 0015g00001QGvxoAAD
[Full_Name__c] => Indrani Lewthwaite
[Id] => 0035g000012uoaUAAQ
[LastModifiedDate] => 2026-02-11T12:35:23.000+0000
[CreatedDate] => 2023-09-04T10:51:00.000+0000
)

[4] => Array
(
[attributes] => Array
(
[type] => Contact
[url] => /services/data/v55.0/sobjects/Contact/003OZ00000QoZGpYAN
)

[Email] => mjanetbatislaon@gmail.com
[FirstName] => Janet
[LastName] => Batislaon
[Contact_Type__c] => Mentor;
[npsp__Primary_Affiliation__c] => 0015g00001NFz5EAAT
[Full_Name__c] => Janet Batislaon
[Id] => 003OZ00000QoZGpYAN
[LastModifiedDate] => 2026-02-11T12:36:03.000+0000
[CreatedDate] => 2025-10-06T21:08:43.000+0000
)

[5] => Array
(
[attributes] => Array
(
[type] => Contact
[url] => /services/data/v55.0/sobjects/Contact/003OZ00000UUTkuYAH
)

[Email] => monanbri@hotmail.com
[FirstName] => Monica
[LastName] => Altmann
[Contact_Type__c] => Mentor;
[npsp__Primary_Affiliation__c] => 001OZ00000at4cbYAA
[Full_Name__c] => Monica Altmann
[Id] => 003OZ00000UUTkuYAH
[LastModifiedDate] => 2026-02-11T12:36:42.000+0000
[CreatedDate] => 2025-12-16T01:15:16.000+0000
)

[6] => Array
(
[attributes] => Array
(
[type] => Contact
[url] => /services/data/v55.0/sobjects/Contact/003J1000001lCPSIA2
)

[Email] => mworsam@gmail.com
[FirstName] => Merrilyn
[LastName] => Worsam
[Contact_Type__c] => Donor; Mentor;
[npsp__Primary_Affiliation__c] => 0015g00001NFyygAAD
[Full_Name__c] => Merrilyn Worsam
[Id] => 003J1000001lCPSIA2
[LastModifiedDate] => 2026-02-11T12:37:32.000+0000
[CreatedDate] => 2024-05-28T04:49:44.000+0000
)

[7] => Array
(
[attributes] => Array
(
[type] => Contact
[url] => /services/data/v55.0/sobjects/Contact/003OZ00000MKb5GYAT
)

[Email] => nataliebubner@outlook.com
[FirstName] => Natalie
[LastName] => Bubner
[Contact_Type__c] => Coordinator; Chaplain;
[npsp__Primary_Affiliation__c] => 0015g00001NFyahAAD
[Full_Name__c] => Natalie Bubner
[Id] => 003OZ00000MKb5GYAT
[LastModifiedDate] => 2026-02-11T12:38:35.000+0000
[CreatedDate] => 2025-06-18T01:50:01.000+0000
)

[8] => Array
(
[attributes] => Array
(
[type] => Contact
[url] => /services/data/v55.0/sobjects/Contact/0035g00001DfVqWAAV
)

[Email] => isoncoral@yahoo.com.au
[FirstName] => Coral
[LastName] => Ison
[Contact_Type__c] => Mentor;
[npsp__Primary_Affiliation__c] => 0015g00001NFz5bAAD
[Full_Name__c] => Coral Ison
[Id] => 0035g00001DfVqWAAV
[LastModifiedDate] => 2026-02-11T12:39:23.000+0000
[CreatedDate] => 2024-03-20T05:42:55.000+0000
)

[9] => Array
(
[attributes] => Array
(
[type] => Contact
[url] => /services/data/v55.0/sobjects/Contact/0035g00001D2N93AAF
)

[Email] => nzlouisemc@gmail.com
[FirstName] => Louise
[LastName] => Forlong
[Contact_Type__c] =>
[npsp__Primary_Affiliation__c] => 0015g00001NFz6IAAT
[Full_Name__c] => Louise Forlong
[Id] => 0035g00001D2N93AAF
[LastModifiedDate] => 2026-02-11T12:39:56.000+0000
[CreatedDate] => 2024-03-07T10:33:01.000+0000
)

[10] => Array
(
[attributes] => Array
(
[type] => Contact
[url] => /services/data/v55.0/sobjects/Contact/003OZ00000TXOECYA5
)

[Email] => noon_hk@hotmail.com
[FirstName] => Wai Shan ( Ada)
[LastName] => Poon
[Contact_Type__c] => Mentor;
[npsp__Primary_Affiliation__c] => 0015g00001NFyxgAAD
[Full_Name__c] => Wai Shan ( Ada) Poon
[Id] => 003OZ00000TXOECYA5
[LastModifiedDate] => 2026-02-11T12:40:28.000+0000
[CreatedDate] => 2025-11-25T08:54:32.000+0000
)

[11] => Array
(
[attributes] => Array
(
[type] => Contact
[url] => /services/data/v55.0/sobjects/Contact/0035g000012unV6AAI
)

[Email] => pastorben@gympiebaptist.org
[FirstName] => Ben
[LastName] => Cumerford
[Contact_Type__c] =>
[npsp__Primary_Affiliation__c] => 0015g00001NFykFAAT
[Full_Name__c] => Ben Cumerford
[Id] => 0035g000012unV6AAI
[LastModifiedDate] => 2026-02-11T12:40:42.000+0000
[CreatedDate] => 2016-08-25T23:16:00.000+0000
)

[12] => Array
(
[attributes] => Array
(
[type] => Contact
[url] => /services/data/v55.0/sobjects/Contact/003J1000003trF5IAI
)

[Email] => pastor@chuwarbaptist.com
[FirstName] => Jay
[LastName] => Beatty
[Contact_Type__c] => Coordinator; Mentor; Pastor/Minister;
[npsp__Primary_Affiliation__c] => 001J1000006Vi9dIAC
[Full_Name__c] => Jay Beatty
[Id] => 003J1000003trF5IAI
[LastModifiedDate] => 2026-02-11T12:40:47.000+0000
[CreatedDate] => 2024-07-07T23:21:29.000+0000
)

[13] => Array
(
[attributes] => Array
(
[type] => Contact
[url] => /services/data/v55.0/sobjects/Contact/0035g000012unsoAAA
)

[Email] => pamelawarren00@gmail.com
[FirstName] => Pamela
[LastName] => Warren
[Contact_Type__c] => Mentor;
[npsp__Primary_Affiliation__c] => 0015g00001NFz5cAAD
[Full_Name__c] => Pamela Warren
[Id] => 0035g000012unsoAAA
[LastModifiedDate] => 2026-02-11T12:40:54.000+0000
[CreatedDate] => 2019-01-31T05:33:00.000+0000
)

[14] => Array
(
[attributes] => Array
(
[type] => Contact
[url] => /services/data/v55.0/sobjects/Contact/003OZ00000Lz8CkYAJ
)

[Email] => pamelaferretti5777@gmail.com
[FirstName] => Pamela
[LastName] => Ferretti
[Contact_Type__c] => Mentor;
[npsp__Primary_Affiliation__c] => 001OZ00000IOHgaYAH
[Full_Name__c] => Pamela Ferretti
[Id] => 003OZ00000Lz8CkYAJ
[LastModifiedDate] => 2026-02-11T12:41:15.000+0000
[CreatedDate] => 2025-06-10T04:18:46.000+0000
)

[15] => Array
(
[attributes] => Array
(
[type] => Contact
[url] => /services/data/v55.0/sobjects/Contact/003OZ00000MHhd1YAD
)

[Email] => patjacksonlighthouse@gmail.com
[FirstName] => Pat
[LastName] => Jackson
[Contact_Type__c] => Coordinator;
[npsp__Primary_Affiliation__c] => 001OZ00000QapJeYAJ
[Full_Name__c] => Pat Jackson
[Id] => 003OZ00000MHhd1YAD
[LastModifiedDate] => 2026-02-11T12:41:50.000+0000
[CreatedDate] => 2025-06-17T04:15:19.000+0000
)

[16] => Array
(
[attributes] => Array
(
[type] => Contact
[url] => /services/data/v55.0/sobjects/Contact/003OZ00000OB7pyYAD
)

[Email] => pamgangell@gmail.com
[FirstName] => Pamela
[LastName] => Gangell
[Contact_Type__c] => Mentor;
[npsp__Primary_Affiliation__c] => 0015g00001NFz1ZAAT
[Full_Name__c] => Pamela Gangell
[Id] => 003OZ00000OB7pyYAD
[LastModifiedDate] => 2026-02-11T12:42:28.000+0000
[CreatedDate] => 2025-08-04T05:34:42.000+0000
)

[17] => Array
(
[attributes] => Array
(
[type] => Contact
[url] => /services/data/v55.0/sobjects/Contact/0035g000016e1T1AAI
)

[Email] => jackie.knights@enjoy.church
[FirstName] => Jackie
[LastName] => Knights
[Contact_Type__c] =>
[npsp__Primary_Affiliation__c] => 0015g00001V652WAAR
[Full_Name__c] => Jackie Knights
[Id] => 0035g000016e1T1AAI
[LastModifiedDate] => 2026-02-11T12:43:08.000+0000
[CreatedDate] => 2023-12-13T06:22:05.000+0000
)

[18] => Array
(
[attributes] => Array
(
[type] => Contact
[url] => /services/data/v55.0/sobjects/Contact/003J10000068N2yIAE
)

[Email] => randaldavis149@gmail.com
[FirstName] => Randal
[LastName] => Davis
[Contact_Type__c] => Coordinator; Mentor;
[npsp__Primary_Affiliation__c] => 0015g00001NFykFAAT
[Full_Name__c] => Randal Davis
[Id] => 003J10000068N2yIAE
[LastModifiedDate] => 2026-02-11T12:43:40.000+0000
[CreatedDate] => 2024-09-19T01:26:16.000+0000
)

[19] => Array
(
[attributes] => Array
(
[type] => Contact
[url] => /services/data/v55.0/sobjects/Contact/003OZ00000TR2zdYAD
)

[Email] => purplefiona59@gmail.com
[FirstName] => Fiona
[LastName] => Turner
[Contact_Type__c] => Mentor;
[npsp__Primary_Affiliation__c] => 0015g00001NFz2YAAT
[Full_Name__c] => Fiona Turner
[Id] => 003OZ00000TR2zdYAD
[LastModifiedDate] => 2026-02-11T12:44:31.000+0000
[CreatedDate] => 2025-11-23T22:55:10.000+0000
)

)

)

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

COPYRIGHT © 2023 KIDS HOPE AUS. All rights reserved.

WEBSITE by