Eloqua-OSC Integration Issues Error in contact import (Doc ID 2719111.1)

Last updated on MAY 11, 2022

Applies to:

Goal

Eloqua-OSC Integration Issues Error in contact import

Qn1:Error messge is as follows:
{
"source": "OracleSalesCloud",
"statusCode": "400",
"reasonPhrase": "Bad Request",
"errorMessage": "Failed to build ViewCriteria from expression \"(EmailAddress like '%@%') AND (LastUpdateDate between '2020-09-18T14:17:01' and '2020-09-27T14:57:00')\" using view object contacts. Unable to create criteria item from node: \"LastUpdateDate\".",
"timestamp": 1601218687434,
"requestUri": "https://xx.xx.oraclecloud.com/crmRestApi/resources/11.13.18.05/contacts?onlyData=true&fields=CreationDate,OwnerName,HomePhoneAreaCode,OwnerPartyId,PersonDEO_MobileEmail_c,FirstName,PersonDEO_ContactEmailFlag_c,EmailAddress,PersonDEO_PhoneticFirstName_c,MobileAreaCode,MobileNumber,PartyNumber,PartyId,HomePhoneNumber,LastName,PersonDEO_PhoneticLastName_c,LastUpdateDate;PrimaryAddress:AddressLine2,AddressLine3,AddressLine1,State,City,PostalCode&q=(EmailAddress+like+'%@%')+AND+(LastUpdateDate+between+'2020-09-18T14:17:01'+and+'2020-09-27T14:57:00')&offset=0&limit=1&totalResults=true",
"requestHeaders": {
"Authorization": "",
"Content-Type": "application/vnd.oracle.adf.resourcecollection+json",
"rest-framework-version": "2"
},

 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.