API Reference

Retrieve account information

List accounts

Call template

All DataTable calls can be POST or GET.

https://{OrangeLogicURL}/API/V2.2/DataTable Contacts.{Contact type}.{Contact subtype}:Read?{search criteria}&SortField={field to sort by}

Identify a set of accounts by type and subtype, and then specify criteria that the accounts must meet. Optionally, you can choose how the returned accounts are sorted by adding SortField to the end of the call. By default, the order of accounts returned by the call reflects the order of the records in the database.

Read

Example 1: Retrieve accounts edited on or before a specific date

This call uses the < operator to return all accounts last edited on or before December 31st, 2015. Date and time information is specified in the format year, month, day.

/API/V2.2/DataTable/Contacts.Client.Default:Read?CoreField.CreateDate<2015-12-31

Example call 
curl --location --request POST 'https://mangovations.com/API/V2.2/DataTable/Contacts.Client.Default:Read?CoreField.CreateDate%3C2015-12-31=null' \
--header 'Authorization: Bearer rP@1W66hmFC8CEDGPrEpdXJ8JUizk8U0YCEH5oGQLNDq9.fH.vObA4JiTeqaByX5AG2.mXq55WR8swrLBmh4QSndZlGoGqJO8g2ucAoWQW8mRunQwyP149KI4yOpPUi5' \
--header 'Cookie: AWSALB=jkujcKN6qllpc3N4fjLMcn33X90UDyPljvPFUVsIOk3kc9EdNmN46auIN0mB3GRbywd1tBui55ct3UnFPjsOMadIR/QfzmH6DCpoSVteTZUE4g10+BJx80Wek4J4; AWSALBCORS=jkujcKN6qllpc3N4fjLMcn33X90UDyPljvPFUVsIOk3kc9EdNmN46auIN0mB3GRbywd1tBui55ct3UnFPjsOMadIR/QfzmH6DCpoSVteTZUE4g10+BJx80Wek4J4; AWSALBTG=LOfTA+IPk7m2pnjOs6Cpa+8zmWKbzwoE/LUjZw/WuLrQsoLJNRpECcriAJLe9XL8zg7yaIW0/7eAG6pxjTgmO8b6XT7rTKUuFUZQ8+0fEl5UzQBfb1xY1lDI+5YftUAl5fLSJbYw2TyrNySMSoiFeNTOLgtl6imMy6VtQQ2mpdkv; AWSALBTGCORS=LOfTA+IPk7m2pnjOs6Cpa+8zmWKbzwoE/LUjZw/WuLrQsoLJNRpECcriAJLe9XL8zg7yaIW0/7eAG6pxjTgmO8b6XT7rTKUuFUZQ8+0fEl5UzQBfb1xY1lDI+5YftUAl5fLSJbYw2TyrNySMSoiFeNTOLgtl6imMy6VtQQ2mpdkv; CortexCID_ZZ1=NK2uiOOw0h7gcj0c; ZZ1-Session__1505=CfDJ8KSkO661hSREsDx7PGb48%2B1JlmwknipTBlvHq9HVEXbQlys25m5nIFiadAkeL7yl7hJBPMWX%2FKVO3F5ilBKkJQFZdKSrqsyF62Tw42YL066K2x6y1hLKqiMwT0pvlmdl83momf2%2FrT7Okkz1MGB1yuP7RYE%2Ff8aRGF7zX9a7OyxI; ZZ1-Session__1505-Alt=CfDJ8KSkO661hSREsDx7PGb48%2B1JlmwknipTBlvHq9HVEXbQlys25m5nIFiadAkeL7yl7hJBPMWX%2FKVO3F5ilBKkJQFZdKSrqsyF62Tw42YL066K2x6y1hLKqiMwT0pvlmdl83momf2%2FrT7Okkz1MGB1yuP7RYE%2Ff8aRGF7zX9a7OyxI'
Response 
<Result>
  <APIRequestInfo>
    <ProviderVersion>KOBE.R2.2065G.216363</ProviderVersion>
    <ProviderIdentity>OLU-T-USW2-APP</ProviderIdentity>
    <ProviderID>44ddde3ac27a33c394335f249d4007d4</ProviderID>
    <Module>DataTable</Module>
    <APIVersion>V2.2</APIVersion>
    <Resource>Contacts.Client.Default:Read</Resource>
    <IsLoggedIn type="Boolean">True</IsLoggedIn>
    <Status>LoggedIn</Status>
    <UserLogin>ZZ1CT12218</UserLogin>
    <Session>No session (production configuration)</Session>
    <TimeoutPeriodMinutes type="Numeric">120</TimeoutPeriodMinutes>
  </APIRequestInfo>
  <RequestInterpretation>
    <Filters type="List">
      <Filter>
        <Field>CoreField.CreateDate</Field>
        <Operator>&lt;</Operator>
        <OperatorDescription>Field must be less than value</OperatorDescription>
        <Value>2015-12-31</Value>
      </Filter>
    </Filters>
    <IgnoredParameters type="List" />
  </RequestInterpretation>
  <ResponseSummary>
    <CurrentPage type="Numeric">1</CurrentPage>
    <ItemsPerPage type="Numeric">30</ItemsPerPage>
    <TotalItemCount type="Numeric">1</TotalItemCount>
  </ResponseSummary>
  <FieldNames>
    <CoreField.First-name>CoreField.first-name</CoreField.First-name>
    <CoreField.Last-name>CoreField.last-name</CoreField.Last-name>
    <CoreField.Login-blocked>CoreField.login-blocked</CoreField.Login-blocked>
    <CoreField.Status>CoreField.status</CoreField.Status>
    <CoreField.Subscribe-to-newsletter>CoreField.subscribe-to-newsletter</CoreField.Subscribe-to-newsletter>
    <CoreField.Account-type>CoreField.account-type</CoreField.Account-type>
    <CoreField.Login-ID>CoreField.login-ID</CoreField.Login-ID>
    <CoreField.Consent-privacy-policy>CoreField.Consent-privacy-policy</CoreField.Consent-privacy-policy>
    <CoreField.Consent-terms-and-conditions>CoreField.consent-terms-and-conditions</CoreField.Consent-terms-and-conditions>
    <CoreField.Display-name>CoreField.display-name</CoreField.Display-name>
  </FieldNames>
  <Response type="List">
    <Record>
      <CoreField.First-name>Jennifer</CoreField.First-name>
      <CoreField.Last-name>Abbot</CoreField.Last-name>
      <CoreField.Login-blocked type="Boolean">False</CoreField.Login-blocked>
      <CoreField.Status>Validated</CoreField.Status>
      <CoreField.Subscribe-to-newsletter type="Boolean">False</CoreField.Subscribe-to-newsletter>
      <CoreField.Account-type>Staff</CoreField.Account-type>
      <CoreField.Login-ID>ZZ1CT17823</CoreField.Login-ID>
      <CoreField.Consent-privacy-policy type="Boolean">False</CoreField.Consent-privacy-policy>
      <CoreField.Consent-terms-and-conditions type="Boolean">False</CoreField.Consent-terms-and-conditions>
      <CoreField.Display-name>Jennifer Abbot</CoreField.Display-name>
      <CoreField.CreateDate type="DateTime">2006-04-06T15:38:00</CoreField.CreateDate>
      <CoreField.EditDate type="DateTime">2011-05-20T06:20:10</CoreField.EditDate>
      <CoreField.EditLocation>O18</CoreField.EditLocation>
      <RecordID>KU1B2PU_D</RecordID>
      <CoreField.Disabled type="Boolean">False</CoreField.Disabled>
    </Record>
  </Response>
</Result>

Example 2: Retrieve accounts edited on or after a specific date and time

This call uses the > operator to return all accounts last edited on or after February 1st, 2025 at 8:00 PM. Date and time information is specified in the format year, month, day followed by 24-hour time. Returned accounts are sorted by the date they were edited.

/API/V2.2/DataTable/Contacts.Client.Default:Read?CoreField.EditDate>2025-02-01T20:00:00&SortField=CoreField.EditDate

Example call 
curl --location --request POST 'https://mangovations.com/API/V2.2/DataTable/Contacts.Client.Default:Read?CoreField.EditDate%3E2025-02-01T20%3A00%3A00=null&SortField=CoreField.EditDate' \
--header 'Authorization: Bearer rP@1W66hmFC8CEDGPrEpdXJ8JUizk8U0YCEH5oGQLNDq9.fH.vObA4JiTeqaByX5AG2.mXq55WR8swrLBmh4QSndZlGoGqJO8g2ucAoWQW8mRunQwyP149KI4yOpPUi5' \
--header 'Cookie: AWSALB=/MQ8Dq9IRJ7qONlaJiQ0XX5GDam7PEZHg6qnA02GKieF1ne1/7C+LC1xPcm8XRaoSSzgzALa4UpDrSeLRIZzPv1xVsmJ98t9fOLU6C5LVj9r1YMSofkVU3BT/fXc; AWSALBCORS=/MQ8Dq9IRJ7qONlaJiQ0XX5GDam7PEZHg6qnA02GKieF1ne1/7C+LC1xPcm8XRaoSSzgzALa4UpDrSeLRIZzPv1xVsmJ98t9fOLU6C5LVj9r1YMSofkVU3BT/fXc; AWSALBTG=XaV1+3SxcEv2I75XpnLTB/9HHHI2ge9Npk4sxxqHTfHEMILWOFnIJGRh8FlnDh5y7P7fFUJe1Ei6AsM6Wtlhs/gAgRcCxiiElFI4pgWCwjHQ0mAKClKwDpYU0/8tYKWkCCJsyN3IHT/xs2dMEVXG8M2u996RnrIeH4bx0mqNCpy6; AWSALBTGCORS=XaV1+3SxcEv2I75XpnLTB/9HHHI2ge9Npk4sxxqHTfHEMILWOFnIJGRh8FlnDh5y7P7fFUJe1Ei6AsM6Wtlhs/gAgRcCxiiElFI4pgWCwjHQ0mAKClKwDpYU0/8tYKWkCCJsyN3IHT/xs2dMEVXG8M2u996RnrIeH4bx0mqNCpy6; CortexCID_ZZ1=NK2uiOOw0h7gcj0c; ZZ1-Session__1505=CfDJ8KSkO661hSREsDx7PGb48%2B2uu4yjqyvhvDxEaJBq6mr%2B0%2BZzk0hd%2FVxUPjwRjCEoLgyK6j5WuHk%2Fdv12WSJnj%2BCwBFo6paC3oU%2BEvVImUm6JVKaGHukJ0fCqFqAslbTcLvwEfyZ0tRvc0pASc2VJfXN2IOravoMXsW1jVX3xNXAl; ZZ1-Session__1505-Alt=CfDJ8KSkO661hSREsDx7PGb48%2B2uu4yjqyvhvDxEaJBq6mr%2B0%2BZzk0hd%2FVxUPjwRjCEoLgyK6j5WuHk%2Fdv12WSJnj%2BCwBFo6paC3oU%2BEvVImUm6JVKaGHukJ0fCqFqAslbTcLvwEfyZ0tRvc0pASc2VJfXN2IOravoMXsW1jVX3xNXAl'
Response 
<Result>
  <APIRequestInfo>
    <ProviderVersion>KOBE.R2.2065G.216363</ProviderVersion>
    <ProviderIdentity>OLU-T-USW2-APP</ProviderIdentity>
    <ProviderID>44ddde3ac27a33c394335f249d4007d4</ProviderID>
    <Module>DataTable</Module>
    <APIVersion>V2.2</APIVersion>
    <Resource>Contacts.Client.Default:Read</Resource>
    <IsLoggedIn type="Boolean">True</IsLoggedIn>
    <Status>LoggedIn</Status>
    <UserLogin>ZZ1CT12218</UserLogin>
    <Session>No session (production configuration)</Session>
    <TimeoutPeriodMinutes type="Numeric">20</TimeoutPeriodMinutes>
  </APIRequestInfo>
  <RequestInterpretation>
    <Filters type="List">
      <Filter>
        <Field>CoreField.EditDate</Field>
        <Operator>&gt;</Operator>
        <OperatorDescription>Field must be geater than value</OperatorDescription>
        <Value>2025-02-01T20:00:00</Value>
      </Filter>
    </Filters>
    <IgnoredParameters type="List" />
  </RequestInterpretation>
  <ResponseSummary>
    <CurrentPage type="Numeric">1</CurrentPage>
    <ItemsPerPage type="Numeric">30</ItemsPerPage>
    <TotalItemCount type="Numeric">6</TotalItemCount>
  </ResponseSummary>
  <FieldNames>
    <CoreField.First-name>CoreField.first-name</CoreField.First-name>
    <CoreField.Last-name>CoreField.last-name</CoreField.Last-name>
    <CoreField.Country>CoreField.country</CoreField.Country>
    <CoreField.Email-address>CoreField.email-address</CoreField.Email-address>
    <CoreField.Login-blocked>CoreField.login-blocked</CoreField.Login-blocked>
    <CoreField.Status>CoreField.status</CoreField.Status>
    <CoreField.Subscribe-to-newsletter>CoreField.subscribe-to-newsletter</CoreField.Subscribe-to-newsletter>
    <CoreField.Account-type>CoreField.account-type</CoreField.Account-type>
    <CoreField.Consent-privacy-policy>CoreField.Consent-privacy-policy</CoreField.Consent-privacy-policy>
    <CoreField.Consent-terms-and-conditions>CoreField.consent-terms-and-conditions</CoreField.Consent-terms-and-conditions>
    <CoreField.Display-name>CoreField.display-name</CoreField.Display-name>
    <CoreField.Unique-identifier>CoreField.unique-identifier</CoreField.Unique-identifier>
    <CoreField.SSO-Status>CoreField.SSO-Status</CoreField.SSO-Status>
    <CoreField.Company-name>CoreField.company-name</CoreField.Company-name>
    <CoreField.Login-ID>CoreField.login-ID</CoreField.Login-ID>
    <CoreField.Administrator>CoreField.administrator</CoreField.Administrator>
    <CoreField.Notes>CoreField.notes</CoreField.Notes>
    <CoreField.Must-reset-password>CoreField.must-reset-password</CoreField.Must-reset-password>
    <CoreField.SSO-ID>CoreField.SSO-ID</CoreField.SSO-ID>
  </FieldNames>
  <Response type="List">
    <Record>
      <CoreField.First-name>Stephen</CoreField.First-name>
      <CoreField.Last-name>Grant</CoreField.Last-name>
      <CoreField.Country>US</CoreField.Country>
      <CoreField.Email-address>[email protected]</CoreField.Email-address>
      <CoreField.Login-blocked type="Boolean">False</CoreField.Login-blocked>
      <CoreField.Status>Validated</CoreField.Status>
      <CoreField.Subscribe-to-newsletter type="Boolean">False</CoreField.Subscribe-to-newsletter>
      <CoreField.Account-type>Staff</CoreField.Account-type>
      <CoreField.Consent-privacy-policy type="Boolean">True</CoreField.Consent-privacy-policy>
      <CoreField.Consent-terms-and-conditions type="Boolean">True</CoreField.Consent-terms-and-conditions>
      <CoreField.Display-name>Stephen Grant</CoreField.Display-name>
      <CoreField.Unique-identifier>ZZ1CT14830     </CoreField.Unique-identifier>
      <CoreField.SSO-Status>NonSSOAllowed</CoreField.SSO-Status>
      <CoreField.CreateDate type="DateTime">2024-12-09T13:50:54</CoreField.CreateDate>
      <CoreField.EditDate type="DateTime">2025-02-04T10:12:50</CoreField.EditDate>
      <CoreField.EditLocation>ZZ1</CoreField.EditLocation>
      <RecordID>K8OEC2AW6NS</RecordID>
      <CoreField.Disabled type="Boolean">False</CoreField.Disabled>
    </Record>
    <Record>
      <CoreField.First-name>Melissa</CoreField.First-name>
      <CoreField.Last-name>Collins</CoreField.Last-name>
      <CoreField.Company-name>Mangovations</CoreField.Company-name>
      <CoreField.Country>US</CoreField.Country>
      <CoreField.Email-address>[email protected]</CoreField.Email-address>
      <CoreField.Login-blocked type="Boolean">False</CoreField.Login-blocked>
      <CoreField.Status>Pending</CoreField.Status>
      <CoreField.Account-type>Staff</CoreField.Account-type>
      <CoreField.Login-ID>ZZ1CT17866</CoreField.Login-ID>
      <CoreField.Consent-privacy-policy type="Boolean">False</CoreField.Consent-privacy-policy>
      <CoreField.Consent-terms-and-conditions type="Boolean">False</CoreField.Consent-terms-and-conditions>
      <CoreField.Administrator>K8OEC00ZZM</CoreField.Administrator>
      <CoreField.Display-name>Melissa Collins</CoreField.Display-name>
      <CoreField.Unique-identifier>ZZ1CT17866     </CoreField.Unique-identifier>
      <CoreField.Notes>Account created, activation pending review. 31 January 2025.</CoreField.Notes>
      <CoreField.SSO-Status>NonSSOAllowed</CoreField.SSO-Status>
      <CoreField.CreateDate type="DateTime">2025-02-03T21:05:29</CoreField.CreateDate>
      <CoreField.EditDate type="DateTime">2025-02-04T21:04:28</CoreField.EditDate>
      <CoreField.EditLocation>ZZ1</CoreField.EditLocation>
      <RecordID>K8OEC0A4OM6</RecordID>
      <CoreField.Disabled type="Boolean">False</CoreField.Disabled>
    </Record>
    <Record>
      <CoreField.First-name>Will</CoreField.First-name>
      <CoreField.Last-name>Hudson</CoreField.Last-name>
      <CoreField.Country>US</CoreField.Country>
      <CoreField.Email-address>[email protected]</CoreField.Email-address>
      <CoreField.Login-blocked type="Boolean">False</CoreField.Login-blocked>
      <CoreField.Status>Validated</CoreField.Status>
      <CoreField.Subscribe-to-newsletter type="Boolean">False</CoreField.Subscribe-to-newsletter>
      <CoreField.Account-type>Source</CoreField.Account-type>
      <CoreField.Consent-privacy-policy type="Boolean">True</CoreField.Consent-privacy-policy>
      <CoreField.Consent-terms-and-conditions type="Boolean">True</CoreField.Consent-terms-and-conditions>
      <CoreField.Display-name>Will Hudson</CoreField.Display-name>
      <CoreField.Unique-identifier>ZZ1CT17003     </CoreField.Unique-identifier>
      <CoreField.SSO-Status>NonSSOAllowed</CoreField.SSO-Status>
      <CoreField.CreateDate type="DateTime">2025-02-06T03:53:35</CoreField.CreateDate>
      <CoreField.EditDate type="DateTime">2025-02-06T13:04:53</CoreField.EditDate>
      <CoreField.EditLocation>ZZ1</CoreField.EditLocation>
      <RecordID>K8OEC0G4FR6</RecordID>
      <CoreField.Disabled type="Boolean">False</CoreField.Disabled>
    </Record>
  </Response>
</Result>