LoyaltyPoint entities
Name | Type | Is Mandatory |
---|---|---|
LoyaltyPointId | Int32 | |
PurchaseHeaderId | Int32 | |
VoucherId | Int32 | |
ContactId | Int32 | |
LoyaltyCardId | Int32 | |
PointTypeId | Int16 | |
PointAmount | Decimal | |
PointOriginalAmount | Decimal | |
PointUsedAmount | Decimal | |
PointExpiredAmount | Decimal | |
DatePoint | DateTime | |
ExpiredDatePoint | DateTime | |
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 | |
DeletionFlag | Boolean | |
PointIdentifier | String | |
SourceId | Int16 | |
PurchaseHeader | PurchaseHeader | |
Contact | Contact | |
LoyaltyCard | LoyaltyCard | |
LoyaltyPointType | LoyaltyPointType | |
Source | Source | |
Voucher | Voucher |
Select all LoyaltyPoints
https://customerapi.fts-crm360.com/data/LoyaltyPoints()
HttpMethod : GET
Json Result :
[
{
"LoyaltyPointId" : "65",
"PurchaseHeaderId" : "62",
"VoucherId" : "13",
"ContactId" : "86",
"LoyaltyCardId" : "16",
"PointTypeId" : "7",
"PointAmount" : "3959268.782",
"PointOriginalAmount" : "4564317.714",
"PointUsedAmount" : "5516179.458",
"PointExpiredAmount" : "3365666.481",
"DatePoint" : "2004-11-27T00:00:00",
"ExpiredDatePoint" : "2004-12-28T00:00:00",
"FreeField1" : "jtxWyj3",
"FreeField2" : "0vN1163encL",
"FreeField3" : "7E2EvrcUz9DGPEBX4ok",
"FreeField4" : "d0SxvrgXa2JPDe0rm",
"FreeField5" : "Gjo1rG",
"FreeFieldDateTime1" : "2012-05-25T00:00:00",
"FreeFieldDateTime2" : "2017-06-18T00:00:00",
"FreeFieldDateTime3" : "2020-12-30T00:00:00",
"FreeFieldDateTime4" : "2009-12-01T00:00:00",
"FreeFieldDateTime5" : "2012-07-20T00:00:00",
"FreeFieldNumber1" : "9839261.899",
"FreeFieldNumber2" : "8845291.155",
"FreeFieldNumber3" : "2158426.222",
"FreeFieldNumber4" : "9817599.398",
"FreeFieldNumber5" : "8962372.352",
"FreeFieldBoolean1" : "True",
"FreeFieldBoolean2" : "True",
"FreeFieldBoolean3" : "True",
"FreeFieldBoolean4" : "True",
"FreeFieldBoolean5" : "True",
"DeletionFlag" : "True",
"PointIdentifier" : "Xi7 2lw79y",
"SourceId" : "7"
},
{
"LoyaltyPointId" : "11",
"PurchaseHeaderId" : "19",
"VoucherId" : "4",
"ContactId" : "73",
"LoyaltyCardId" : "8",
"PointTypeId" : "7",
"PointAmount" : "7343579.361",
"PointOriginalAmount" : "6351456.671",
"PointUsedAmount" : "8938349.523",
"PointExpiredAmount" : "1877315.189",
"DatePoint" : "2022-11-22T00:00:00",
"ExpiredDatePoint" : "2015-04-03T00:00:00",
"FreeField1" : "hKsgwSlk",
"FreeField2" : "AExv gELscFU",
"FreeField3" : "vjyuS7ft CLtwsf MOl",
"FreeField4" : "o l3hEB pLel4la",
"FreeField5" : "uA oDvM",
"FreeFieldDateTime1" : "1995-11-01T00:00:00",
"FreeFieldDateTime2" : "2012-03-25T00:00:00",
"FreeFieldDateTime3" : "1996-01-31T00:00:00",
"FreeFieldDateTime4" : "2001-11-28T00:00:00",
"FreeFieldDateTime5" : "2018-12-11T00:00:00",
"FreeFieldNumber1" : "6453563.999",
"FreeFieldNumber2" : "2395166.682",
"FreeFieldNumber3" : "3412396.966",
"FreeFieldNumber4" : "3582437.313",
"FreeFieldNumber5" : "3528877.676",
"FreeFieldBoolean1" : "True",
"FreeFieldBoolean2" : "False",
"FreeFieldBoolean3" : "True",
"FreeFieldBoolean4" : "False",
"FreeFieldBoolean5" : "True",
"DeletionFlag" : "False",
"PointIdentifier" : "V i6 TZm",
"SourceId" : "7"
},
...
]
Select LoyaltyPoint by Id
https://customerapi.fts-crm360.com/data/LoyaltyPoints(65)
HttpMethod : GET
Json Result :
{
"LoyaltyPointId" : "39",
"PurchaseHeaderId" : "71",
"VoucherId" : "8",
"ContactId" : "77",
"LoyaltyCardId" : "95",
"PointTypeId" : "3",
"PointAmount" : "5587234.521",
"PointOriginalAmount" : "2113377.314",
"PointUsedAmount" : "3548282.141",
"PointExpiredAmount" : "5962572.719",
"DatePoint" : "2023-11-27T00:00:00",
"ExpiredDatePoint" : "2009-12-17T00:00:00",
"FreeField1" : "0LQSSamB1v",
"FreeField2" : "A9J kZCOFMlU 5",
"FreeField3" : "jl4MBWwMgr6d5qx9n",
"FreeField4" : "AJeiKLm",
"FreeField5" : "v IO20Yc1 HpsPPxoUo",
"FreeFieldDateTime1" : "2022-01-13T00:00:00",
"FreeFieldDateTime2" : "1998-12-27T00:00:00",
"FreeFieldDateTime3" : "2011-08-05T00:00:00",
"FreeFieldDateTime4" : "2004-04-29T00:00:00",
"FreeFieldDateTime5" : "2001-04-15T00:00:00",
"FreeFieldNumber1" : "9247414.761",
"FreeFieldNumber2" : "6413811.587",
"FreeFieldNumber3" : "8957979.857",
"FreeFieldNumber4" : "8219374.628",
"FreeFieldNumber5" : "6416697.456",
"FreeFieldBoolean1" : "True",
"FreeFieldBoolean2" : "True",
"FreeFieldBoolean3" : "False",
"FreeFieldBoolean4" : "True",
"FreeFieldBoolean5" : "False",
"DeletionFlag" : "True",
"PointIdentifier" : "n0mGjL3SaPI Hoc",
"SourceId" : "4"
}
Create a LoyaltyPoint
https://customerapi.fts-crm360.com/data/LoyaltyPoints()
HttpMethod : POST
Json Post :
{
"PurchaseHeaderId" : "97",
"VoucherId" : "17",
"ContactId" : "45",
"LoyaltyCardId" : "91",
"PointTypeId" : "8",
"PointAmount" : "2115498.245",
"PointOriginalAmount" : "6398857.122",
"PointUsedAmount" : "3266449.447",
"PointExpiredAmount" : "4919586.623",
"DatePoint" : "1995-06-27T00:00:00",
"ExpiredDatePoint" : "2000-01-17T00:00:00",
"FreeField1" : "sktJ",
"FreeField2" : "QIOtg6XbL Cfyo",
"FreeField3" : "oMEU95I",
"FreeField4" : "KIM7 nMErfgPqWWi",
"FreeField5" : "JXMKfYWi6gE",
"FreeFieldDateTime1" : "2009-09-07T00:00:00",
"FreeFieldDateTime2" : "2015-07-04T00:00:00",
"FreeFieldDateTime3" : "2021-11-13T00:00:00",
"FreeFieldDateTime4" : "1998-03-30T00:00:00",
"FreeFieldDateTime5" : "2004-04-09T00:00:00",
"FreeFieldNumber1" : "3647456.898",
"FreeFieldNumber2" : "3299877.577",
"FreeFieldNumber3" : "6867841.226",
"FreeFieldNumber4" : "9649489.817",
"FreeFieldNumber5" : "8427136.964",
"FreeFieldBoolean1" : "True",
"FreeFieldBoolean2" : "False",
"FreeFieldBoolean3" : "True",
"FreeFieldBoolean4" : "False",
"FreeFieldBoolean5" : "False",
"DeletionFlag" : "False",
"PointIdentifier" : "o4AYbrXzrt8hDv8dC7",
"SourceId" : "2"
}
Informations :
- Non mandatory fields are optional for Json Post
Update a LoyaltyPoint
https://customerapi.fts-crm360.com/data/LoyaltyPoints(65)
HttpMethod : PUT
Json Post :
{
"LoyaltyPointId" : "60",
"PurchaseHeaderId" : "95",
"VoucherId" : "65",
"ContactId" : "61",
"LoyaltyCardId" : "74",
"PointTypeId" : "1",
"PointAmount" : "5788413.193",
"PointOriginalAmount" : "9134788.457",
"PointUsedAmount" : "4667714.589",
"PointExpiredAmount" : "9333995.136",
"DatePoint" : "2016-08-31T00:00:00",
"ExpiredDatePoint" : "2010-09-05T00:00:00",
"FreeField1" : "Ccujcw",
"FreeField2" : "OGCr2",
"FreeField3" : "FEUqtK",
"FreeField4" : "VntBZyU2I073 NsPX B",
"FreeField5" : "3vKOl",
"FreeFieldDateTime1" : "1998-02-08T00:00:00",
"FreeFieldDateTime2" : "2019-07-14T00:00:00",
"FreeFieldDateTime3" : "2006-12-30T00:00:00",
"FreeFieldDateTime4" : "2022-01-04T00:00:00",
"FreeFieldDateTime5" : "2022-07-08T00:00:00",
"FreeFieldNumber1" : "9143147.727",
"FreeFieldNumber2" : "4213285.848",
"FreeFieldNumber3" : "9871165.543",
"FreeFieldNumber4" : "9992895.223",
"FreeFieldNumber5" : "5764676.928",
"FreeFieldBoolean1" : "False",
"FreeFieldBoolean2" : "False",
"FreeFieldBoolean3" : "False",
"FreeFieldBoolean4" : "False",
"FreeFieldBoolean5" : "True",
"DeletionFlag" : "False",
"PointIdentifier" : "PKc8PP2tgO",
"SourceId" : "8"
}
Informations :
- Non mandatory fields are optional for Json Post
Patch a LoyaltyPoint
https://customerapi.fts-crm360.com/data/LoyaltyPoints(65)
HttpMethod : PATCH
Json Post :
{
"FreeFieldNumber1" : "4233713.323",
"PointTypeId" : "5",
"FreeFieldBoolean4" : "True",
"PointAmount" : "9646619.827",
"FreeFieldNumber3" : "6317434.862",
"FreeField1" : "xe6hXN5xu5A",
"PointIdentifier" : "ygZ2lNtmXppl PBw",
"FreeFieldDateTime2" : "1996-03-31T00:00:00",
"SourceId" : "8",
"PointOriginalAmount" : "4649215.138",
"FreeFieldDateTime4" : "2023-07-27T00:00:00"
}
Informations :
- Non mandatory fields are optional for Json Post
Delete a LoyaltyPoint
https://customerapi.fts-crm360.com/data/LoyaltyPoints(65)
HttpMethod : DELETE