CRM360° CustomerApi Documentation
Return to Odata Help Page

Customer - Contact

Manage contact entities excepting addresses (Cf Address entity)

Required HTTP Headers

  • X-Crm360Api-Token
  • X-Crm360Api-CustomerName
  • X-Crm360Api-DatabaseAlias

Functions

Entity Properties

Name Type Is Mandatory
ContactId Int32
GenderId Int16
CivilityId Int16
TitleId Int16
FirstName String
MiddleName String
LastName String
LastName2 String
FirstNameSecondAlphabet String
MiddleNameSecondAlphabet String
LastNameSecondAlphabet String
LastName2SecondAlphabet String
BirthDate DateTime
BirthDay Int16
BirthMonth Int16
BirthYear Int16
MaritalStatusId Int16
JobTitle String
CompanyName String
GlobalOptin Boolean
GlobalPartnerOptin Boolean
ContactStateId Int16
ContactTypeId Int16
AdvertiserCreationDate DateTime
NationalityId Int16
LanguageId String
DeletionFlag Boolean
FreeField1 String
FreeField2 String
FreeField3 String
FreeField4 String
FreeField5 String
FreeFieldDateTime1 DateTime
FreeFieldDateTime2 DateTime
FreeFieldDateTime3 DateTime
FreeFieldDateTime4 DateTime
FreeFieldDateTime5 DateTime
FreeFieldNumber1 Decimal
FreeFieldNumber2 Decimal
FreeFieldNumber3 Decimal
FreeFieldNumber4 Decimal
FreeFieldNumber5 Decimal
FreeFieldBoolean1 Boolean
FreeFieldBoolean2 Boolean
FreeFieldBoolean3 Boolean
FreeFieldBoolean4 Boolean
FreeFieldBoolean5 Boolean
ZoneId Int32
ZoneIdString String
Civility Civility
Zone Zone
PurchaseHeaders Collection of PurchaseHeader
Gender Gender
Title Title
MaritalStatus MaritalStatus
ContactState ContactState
Nationality Nationality
Language Language
ContactType ContactType
ContactIdentifiers Collection of ContactIdentifier
MarketingParticipants Collection of MarketingParticipant
LoyaltyCards Collection of LoyaltyCard
LoyaltyPoints Collection of LoyaltyPoint
AttachedStores Collection of AttachedStore
ContactDescendantLinks Collection of ContactLink
ContactAscendantLinks Collection of ContactLink
Cases Collection of Case
Vouchers Collection of Voucher
Segments Collection of Segment
Addresses Collection of Address
ContactInterests Collection of ContactInterest

Actions

Action Name Method Parameters Description Return
SumPurchaseHeader POST
  • column (String)
  • year (Int32)
  • brandId (Int32)
 Compute Sum of chosen column of related PurchaseHeader entities Decimal 
Example
https://customerapi.fts-crm360.com/data/Contacts(32)/SumPurchaseHeader?column=Amount&year=2014&brandId=1


HttpMethod : POST
                                                                                       

Informations : 
           - column = Amount | TaxFreeAmount | DiscountAmount | RefAmount | RefTaxFreeAmount | RefDiscountAmount
            - brandId is optional
            - year is optional
SumPurchaseDetail POST
  • column (String)
  • year (Int32)
  • brandId (Int32)
 Compute Sum of chosen column of related PurchaseDetail entities Decimal 
Example
https://customerapi.fts-crm360.com/data/Contacts(32)/SumPurchaseDetail?column=Amount&year=2014&brandId=1


HttpMethod : POST
                                                                                       

Informations : 
           - column = Amount | TaxFreeAmount | DiscountAmount | RefAmount | RefTaxFreeAmount | RefDiscountAmount | Quantity
            - brandId is optional
            - year is optional
SumLoyaltyPoint POST
  • column (String)
  • loyaltyPointTypeId (Int32)
  • loyaltyCardTypeId (Int32)
  • brandId (Int32)
  • firstContactId (Int32)
  • secondContactId (Int32)
  • consolidationRuleId (Int32)
  • contactList (String)
  • consolidationRuleId (Int32)
 Compute Sum of chosen column of related LoyaltyPoint entities Decimal 
Example
https://customerapi.fts-crm360.com/data/Contacts(32)/SumLoyaltyPoint?column=Amount&loyaltyPointTypeId=1&loyaltyCardTypeId=2&brandId=1


HttpMethod : POST
                                                                                       

Informations : 
           - column = PointAmount | PointOriginalAmount | PointUsedAmount | PointExpiredAmount
            - loyaltyPointTypeId is optional
            - loyaltyCardTypeId is optional
            - brandId is optional

Examples

Select all Contacts
https://customerapi.fts-crm360.com/data/Contacts()


HttpMethod : GET
                                                                                       

Json Result : 

[
{
"ContactId" : "8",
"GenderId" : "7",
"CivilityId" : "6",
"TitleId" : "6",
"FirstName" : "8fsXiZ38ecEC dT1",
"MiddleName" : "uZu6ug1hLKk6x1MDy",
"LastName" : "SzFnK8Eq lSV7",
"LastName2" : "vRAI0 O 0 WNTAtl29N",
"FirstNameSecondAlphabet" : "ABsFOw0CsQP1OkKf0C",
"MiddleNameSecondAlphabet" : "8VT8QR8p",
"LastNameSecondAlphabet" : "8NtUH",
"LastName2SecondAlphabet" : "9sj55",
"BirthDate" : "1997-01-30T00:00:00",
"BirthDay" : "9",
"BirthMonth" : "2",
"BirthYear" : "3",
"MaritalStatusId" : "6",
"JobTitle" : "f u0Nw vQjtEa",
"CompanyName" : "QGxEdi5uMlc65HJ9J",
"GlobalOptin" : "True",
"GlobalPartnerOptin" : "True",
"ContactStateId" : "7",
"ContactTypeId" : "7",
"AdvertiserCreationDate" : "2023-06-09T00:00:00",
"NationalityId" : "9",
"LanguageId" : "vc3k2cQn",
"DeletionFlag" : "False",
"FreeField1" : "p8MFzA",
"FreeField2" : "xyHXR0rkRZrsvCS",
"FreeField3" : "jV pV1u",
"FreeField4" : "0z dMwDNW",
"FreeField5" : "Ky0cnM kDj5XBWxnvyX",
"FreeFieldDateTime1" : "2004-08-23T00:00:00",
"FreeFieldDateTime2" : "2021-10-23T00:00:00",
"FreeFieldDateTime3" : "1996-10-23T00:00:00",
"FreeFieldDateTime4" : "2018-04-19T00:00:00",
"FreeFieldDateTime5" : "2010-08-07T00:00:00",
"FreeFieldNumber1" : "5124535.471",
"FreeFieldNumber2" : "2478454.367",
"FreeFieldNumber3" : "9482423.497",
"FreeFieldNumber4" : "1213969.617",
"FreeFieldNumber5" : "1569349.849",
"FreeFieldBoolean1" : "False",
"FreeFieldBoolean2" : "True",
"FreeFieldBoolean3" : "True",
"FreeFieldBoolean4" : "False",
"FreeFieldBoolean5" : "True",
"ZoneId" : "5",
"ZoneIdString" : "E8X CXC"
},
{
"ContactId" : "1",
"GenderId" : "4",
"CivilityId" : "4",
"TitleId" : "9",
"FirstName" : "cuN6qYyz3APb Dsb",
"MiddleName" : "9s6Z4prtBKj O c",
"LastName" : "pbQZcWNPZM6HjCTWhRZ",
"LastName2" : "8WiEhNoMO oAxcV",
"FirstNameSecondAlphabet" : "aBQndr stiI92N",
"MiddleNameSecondAlphabet" : "7muAS3L2Ps",
"LastNameSecondAlphabet" : "ki5VF",
"LastName2SecondAlphabet" : "q5fAxPQW1W9DqVA",
"BirthDate" : "2006-04-09T00:00:00",
"BirthDay" : "7",
"BirthMonth" : "4",
"BirthYear" : "1",
"MaritalStatusId" : "5",
"JobTitle" : "uPKA5",
"CompanyName" : "q JzMCQLS76",
"GlobalOptin" : "False",
"GlobalPartnerOptin" : "False",
"ContactStateId" : "9",
"ContactTypeId" : "1",
"AdvertiserCreationDate" : "2019-04-04T00:00:00",
"NationalityId" : "8",
"LanguageId" : "Bq L1fS",
"DeletionFlag" : "True",
"FreeField1" : "7qV 2xl7riw ZIu",
"FreeField2" : "wjjsFraR02y",
"FreeField3" : "NSS5ZkPnl68sJ V",
"FreeField4" : "GJngQvE6t",
"FreeField5" : "jPOCK 95tYP1lz4G00m",
"FreeFieldDateTime1" : "2020-05-04T00:00:00",
"FreeFieldDateTime2" : "2011-03-21T00:00:00",
"FreeFieldDateTime3" : "1997-09-26T00:00:00",
"FreeFieldDateTime4" : "2005-04-07T00:00:00",
"FreeFieldDateTime5" : "1999-05-14T00:00:00",
"FreeFieldNumber1" : "2733452.425",
"FreeFieldNumber2" : "1945797.339",
"FreeFieldNumber3" : "1368629.338",
"FreeFieldNumber4" : "4591957.753",
"FreeFieldNumber5" : "2962897.316",
"FreeFieldBoolean1" : "True",
"FreeFieldBoolean2" : "False",
"FreeFieldBoolean3" : "True",
"FreeFieldBoolean4" : "True",
"FreeFieldBoolean5" : "False",
"ZoneId" : "90",
"ZoneIdString" : "aoPj9A"
},
...
]
            
                                                     

Select Contact by Id
https://customerapi.fts-crm360.com/data/Contacts(8)


HttpMethod : GET
                                                                                       

Json Result : 

{
"ContactId" : "35",
"GenderId" : "1",
"CivilityId" : "5",
"TitleId" : "1",
"FirstName" : "pQN tCxGm",
"MiddleName" : "samJrtDqf8",
"LastName" : "YUDQpL2TDQ bn aHlvn",
"LastName2" : "Rr 6z",
"FirstNameSecondAlphabet" : "Vn 1lUp336bYkPTWv3",
"MiddleNameSecondAlphabet" : "UPkc628sr5HctXgqCZ",
"LastNameSecondAlphabet" : "G87hLIWB",
"LastName2SecondAlphabet" : "9UpCz8eFCh6tX8L9",
"BirthDate" : "2018-07-17T00:00:00",
"BirthDay" : "9",
"BirthMonth" : "7",
"BirthYear" : "2",
"MaritalStatusId" : "7",
"JobTitle" : "TWp2AYsYTk0LtW",
"CompanyName" : "Epw2amfd",
"GlobalOptin" : "False",
"GlobalPartnerOptin" : "True",
"ContactStateId" : "1",
"ContactTypeId" : "7",
"AdvertiserCreationDate" : "2011-08-13T00:00:00",
"NationalityId" : "4",
"LanguageId" : "q BVATY",
"DeletionFlag" : "True",
"FreeField1" : "FYpOV2KO0ttU5VR z2I",
"FreeField2" : "oI J4",
"FreeField3" : "IYV7r",
"FreeField4" : "wC8RHokx50q wd",
"FreeField5" : "UNaPz6cPqEb1A1ex",
"FreeFieldDateTime1" : "1995-08-21T00:00:00",
"FreeFieldDateTime2" : "2012-11-18T00:00:00",
"FreeFieldDateTime3" : "1997-10-18T00:00:00",
"FreeFieldDateTime4" : "2011-11-24T00:00:00",
"FreeFieldDateTime5" : "2001-10-25T00:00:00",
"FreeFieldNumber1" : "1575537.333",
"FreeFieldNumber2" : "2541255.983",
"FreeFieldNumber3" : "8327769.416",
"FreeFieldNumber4" : "2795377.737",
"FreeFieldNumber5" : "7947336.843",
"FreeFieldBoolean1" : "False",
"FreeFieldBoolean2" : "False",
"FreeFieldBoolean3" : "True",
"FreeFieldBoolean4" : "False",
"FreeFieldBoolean5" : "True",
"ZoneId" : "77",
"ZoneIdString" : "Cu9STPqFco"
}
            
                                                     

Create a Contact
https://customerapi.fts-crm360.com/data/Contacts()


HttpMethod : POST
                                                                                                

Json Post :
{
"GenderId" : "8",
"CivilityId" : "7",
"TitleId" : "4",
"FirstName" : "soLk16aXb6HBwEgcn",
"MiddleName" : "eVn SZ",
"LastName" : "srp0rxA7d2B",
"LastName2" : "qj04r",
"FirstNameSecondAlphabet" : "CKRdkj  v",
"MiddleNameSecondAlphabet" : "EKrWxKJPx",
"LastNameSecondAlphabet" : "wJFESNdb8hpb",
"LastName2SecondAlphabet" : "uOOHNFE0rAv1SKrPeZk",
"BirthDate" : "1998-07-04T00:00:00",
"BirthDay" : "2",
"BirthMonth" : "5",
"BirthYear" : "9",
"MaritalStatusId" : "1",
"JobTitle" : "KXEjBNmn",
"CompanyName" : "8GhC6Jrr",
"GlobalOptin" : "True",
"GlobalPartnerOptin" : "False",
"ContactStateId" : "4",
"ContactTypeId" : "3",
"AdvertiserCreationDate" : "1995-01-02T00:00:00",
"NationalityId" : "1",
"LanguageId" : "LcHDUyNWK5Bt Roz",
"DeletionFlag" : "False",
"FreeField1" : "DMjsacaa",
"FreeField2" : "aws9KUSXkEi",
"FreeField3" : "avwXI4br",
"FreeField4" : "UO 60OeApo4",
"FreeField5" : "xkc72Ys4C",
"FreeFieldDateTime1" : "2016-01-10T00:00:00",
"FreeFieldDateTime2" : "2011-11-09T00:00:00",
"FreeFieldDateTime3" : "2022-01-05T00:00:00",
"FreeFieldDateTime4" : "2013-08-19T00:00:00",
"FreeFieldDateTime5" : "2008-04-01T00:00:00",
"FreeFieldNumber1" : "8436971.945",
"FreeFieldNumber2" : "9351854.941",
"FreeFieldNumber3" : "9292119.546",
"FreeFieldNumber4" : "6134427.162",
"FreeFieldNumber5" : "3829969.615",
"FreeFieldBoolean1" : "True",
"FreeFieldBoolean2" : "True",
"FreeFieldBoolean3" : "True",
"FreeFieldBoolean4" : "False",
"FreeFieldBoolean5" : "False",
"ZoneId" : "61",
"ZoneIdString" : "Fh6vil  47F"
}
            


Informations : 
 - Non mandatory fields are optional for Json Post
                                                     

Update a Contact
https://customerapi.fts-crm360.com/data/Contacts(8)


HttpMethod : PUT
                                                                                                

Json Post :
{
"ContactId" : "61",
"GenderId" : "7",
"CivilityId" : "8",
"TitleId" : "3",
"FirstName" : "O KB5O J",
"MiddleName" : "d2T iw4 tn",
"LastName" : "t uLUJDqyBSr8",
"LastName2" : "RsTkg2HxZDu",
"FirstNameSecondAlphabet" : "VLLx MxhzE",
"MiddleNameSecondAlphabet" : "vJvWSKLWkQClPMv",
"LastNameSecondAlphabet" : "7ApczUtdlPS",
"LastName2SecondAlphabet" : "L2dnU2wsY F4",
"BirthDate" : "2010-12-18T00:00:00",
"BirthDay" : "2",
"BirthMonth" : "3",
"BirthYear" : "1",
"MaritalStatusId" : "2",
"JobTitle" : "gzcWlyag3 bQv",
"CompanyName" : "3sJsy",
"GlobalOptin" : "False",
"GlobalPartnerOptin" : "False",
"ContactStateId" : "4",
"ContactTypeId" : "4",
"AdvertiserCreationDate" : "1995-12-12T00:00:00",
"NationalityId" : "1",
"LanguageId" : "5w5oEoV tdB0",
"DeletionFlag" : "True",
"FreeField1" : "Ly9VQGqC 0 iRtU",
"FreeField2" : "Y TD3qm",
"FreeField3" : "Vz6vU qU",
"FreeField4" : "GOdZEw601vD",
"FreeField5" : "gWnqkEmgMygKu",
"FreeFieldDateTime1" : "2008-01-19T00:00:00",
"FreeFieldDateTime2" : "2000-06-05T00:00:00",
"FreeFieldDateTime3" : "2022-01-20T00:00:00",
"FreeFieldDateTime4" : "2016-06-22T00:00:00",
"FreeFieldDateTime5" : "2012-07-03T00:00:00",
"FreeFieldNumber1" : "2722587.364",
"FreeFieldNumber2" : "3195685.317",
"FreeFieldNumber3" : "3182373.713",
"FreeFieldNumber4" : "7922994.228",
"FreeFieldNumber5" : "8892976.622",
"FreeFieldBoolean1" : "True",
"FreeFieldBoolean2" : "False",
"FreeFieldBoolean3" : "False",
"FreeFieldBoolean4" : "False",
"FreeFieldBoolean5" : "False",
"ZoneId" : "12",
"ZoneIdString" : "61wiDNUoS4wpoaRJP5"
}
            


Informations : 
 - Non mandatory fields are optional for Json Post
                                                     

Patch a Contact
https://customerapi.fts-crm360.com/data/Contacts(8)


HttpMethod : PATCH
                                                                                                

Json Post :
{
"FreeFieldNumber1" : "5162516.594",
"FreeField1" : "DH3xDbUYQwjneq119",
"FreeField2" : "vstlEu PtTq4"
}
            


Informations : 
 - Non mandatory fields are optional for Json Post
                                                     

Delete a Contact
https://customerapi.fts-crm360.com/data/Contacts(8)


HttpMethod : DELETE