Display Member Activities
Use the Member Activity REST resource to retrieve members' activity statements. The activity statements that are returned show the history of all the accruals and redemptions along with the transactions in which they were made. You can use the resource response when building your own applications to display the detailed information about members' points and their movements, similar to bank activity statements. Using the resource for queries also returns custom attributes that have been added to the Transaction object.
By default, this resource returns the 25 most recently accrued, redeemed, or expired point transactions and provides the option to retrieve 25 more items. If you want to display 30 items on each page, you can set a limit to 30 in the request as follows:
/crmRestApi/resources/11.13.18.05/loyMembers/[MemberNumber]/child/activities?limit=30)
The Member Activity resource is a child of the Member resource. You can retrieve the resource link using the following URL:
/crmRestApi/resources/11.13.18.05/loyMembers/{MemberNumber}
Note:
Oracle Loyalty only supports the GET method, and doesn't support the POST or DELETE or PATCH methods.Example of Displaying All Member Activities
Example URLThe following is an example of the resource URL to retrieve all activities for a member.
GET
https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/{MemberNumber}/child/activities
Example Response
{
"items": [
{
"LoyTransactionId": 300100148449625,
"ProcessDt": "2018-03-13T07:30:49.023+00:00",
"AccrualProgPointBlockId": null,
"AccrualTotalPoints": null,
"AccrualPromotionName": null,
"AccrualLoyPromoId": null,
"AccrualPointBlockNumber": null,
"RedemptionValue": null,
"LoyRdmItmId": null,
"LoyAcrlItmId": null,
"AcrlTransactionId": null,
"AcrlStatusCode": null,
"ProdId": 999994000663205,
"CreatedBy": "LOYALTY_PROGRAM_ADMINISTRATOR",
"CreationDate": "2018-03-15T06:48:14.837+00:00",
"LastUpdatedBy": "LOYALTY_PROGRAM_ADMINISTRATOR",
"LastUpdateDate": "2018-03-15T06:48:15.104+00:00",
"LastUpdateLogin": "676E8D5CDACB43A5E0534280F50A521F",
"ExternalTransaction": "N",
"QualifyingPointUsed": "N",
"StatusCode": "ORA_TXN_STAT_IN_PROG",
"TypeCode": "ORA_TXN_RED",
"SubTypeCode": "ORA_RED_CNCL",
"TransactionNumber": "300100148449625",
"UnaccMinor": "N",
"ApproveDt": null,
"CurcyExchDt": null,
"EndDt": null,
"ExpireInDays": null,
"InternalFlightDt": null,
"LoanBalance": null,
"LoanRepaymentDt": null,
"Points": 23,
"OptyCost": null,
"PostDt": null,
"PtnrProcDt": null,
"StartDt": "2018-03-13T07:30:24.405+00:00",
"SubmitDt": null,
"TransactionDate": "2018-03-15T06:48:15.756+00:00",
"BookClassCode": null,
"CancelledTransactionId": 300100148448790,
"Comments": null,
"CurcyCode": "USD",
"DestAirportCode": null,
"DestZoneCode": null,
"DocumentNumber": null,
"ExternalReservationNumber": null,
"FareBasis": null,
"FareBasisCode": null,
"FareTypeCode": null,
"FlightNumber": null,
"FltTypeCode": null,
"GdsRecLocator": null,
"IntegrationId": null,
"InternalDest": null,
"InternalOrigin": null,
"ItemNumber": null,
"LocationCode": null,
"OrigAirportCode": null,
"OrigOrderId": null,
"OrigZoneCode": null,
"OwnerId": null,
"PartitionName": null,
"ParentTransactionId": null,
"PnrName": null,
"ProcessingComment": null,
"ProcessingLog": "Assigned Points: 43.0 Beans, Expiry Date: Mon Oct 01 23:59:59 UTC 2018 ()<br>Assigned Product Voucher: 1 Pro 500, Expiry Date: Tue Mar 13 07:30:24 UTC 2018 ()<br>",
"PtnrStatusCode": null,
"SubStatusCode": "ORA_TXN_SUB_STAT_SUCCESS",
"TicketNumber": null,
"TrvClassCode": null,
"TransactionChannelCode": "ORA_TXN_CHANNEL_MSR",
"AmountValue": 43,
"BookingDt": null,
"CancReasonCode": null,
"CorporateReferenceNumber": null,
"MarketingFlightNumber": null,
"OrderNumber": null,
"OrigOrdItmId": null,
"OrigPoints": null,
"OvrDupCheck": "N",
"PriceOverriden": "N",
"PackageCode": null,
"PymtTypeCode": null,
"RedemptionQuantityUOMCode": null,
"RefundPct": null,
"RfndOvrdCmnts": null,
"RfndOvrdRsnCode": null,
"SourceCode": null,
"ToMemberNumber": null,
"TotalLines": null,
"TrvlDistance": null,
"TransactionSourceCode": null,
"PeriodTypeCode": null,
"ReasonCode": null,
"ChildTransactionId": null,
"PeriodDurCode": null,
"ActivityDay": null,
"ActivityHour": null,
"ValStatusCode": null,
"DestCityCode": null,
"OriginCityCode": null,
"IncentivChoice": null,
"SmActionTypeCode": null,
"InvOrgId": 204,
"LineItemNumber": null,
"PnrNumber": null,
"ActivityDate": "2018-03-13T07:30:24.405+00:00",
"CorpCurrencyCode": "EUR",
"CurcyConvRateType": "Corporate",
"ExternalProductName": null,
"ExternalProductType": null,
"ExternalProductLine": null,
"TotalDays": null,
"AccrualDisputeStatusCode": null,
"AccrualDisputeTypeCode": null,
"AccrualedValue": null,
"ProgramNumber": "CDRM_10",
"ProgramName": "BIQA_LOYALTY_Starbucks",
"PartyName": "Stryker Corp.",
"PartyId": 100000016934002,
"ProductName": "Pro 400",
"InventoryItemId": 999994000663205,
"OrganizationId": 204,
"StatusMeaning": "In Progress",
"RedemptionProgPointBlockId": null,
"RedemptionTotalPoints": null,
"RedemptionPointBlockNumber": null,
"RedemptionLoyPromoId": null,
"RedemptionPromotionName": null,
"TypeMeaning": "Redemption",
"SubTypeMeaning": "Cancellation",
"TransactionEO_Test_c": null,
"TransactionEO_Update_c": null,
"TransactionEO_TXN_TEXT_c": null,
"TransactionEO_TXN_NUM_c": null,
"TransactionEO_TXN_DATE_c": null,
"TransactionEO_TXN_CB_c": null,
"TransactionEO_TXN_PER_c": null,
"TransactionEO_TXN_DT_c": null,
"TransactionEO_TXN_CURR_c": null,
"TransactionEO_TXN_FCL_c": null,
"TransactionEO_TXN_FOR_c": 100,
"TransactionEO_TXN_RT_c": null,
"links": [
{
"rel": "self",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100148449625",
"name": "activities",
"kind": "item"
},
{
"rel": "canonical",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100148449625",
"name": "activities",
"kind": "item"
},
{
"rel": "parent",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832",
"name": "loyMembers",
"kind": "item"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100148449625/lov/TransactionEO_LOVVA_For_TXN_FCL_c",
"name": "TransactionEO_LOVVA_For_TXN_FCL_c",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100148449625/lov/TransactionEO_LOVVA_For_TXN_RT_c",
"name": "TransactionEO_LOVVA_For_TXN_RT_c",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100148449625/lov/TransactionEO_LOVVA_For_TXN_CB_c",
"name": "TransactionEO_LOVVA_For_TXN_CB_c",
"kind": "collection"
},
{
"rel": "enclosure",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100148449625/enclosure/TransactionEO_TXN_LT_c",
"name": "TransactionEO_TXN_LT_c",
"kind": "other"
}
]
},
{
"LoyTransactionId": 300100148448790,
"ProcessDt": "2018-03-13T07:30:49.023+00:00",
"AccrualProgPointBlockId": null,
"AccrualTotalPoints": null,
"AccrualPromotionName": "BIQA_LOYALTY_ACCRUAL_PROMOTION",
"AccrualLoyPromoId": 300100126038723,
"AccrualPointBlockNumber": null,
"RedemptionValue": null,
"LoyRdmItmId": null,
"LoyAcrlItmId": 300100148448791,
"AcrlTransactionId": 300100148448790,
"AcrlStatusCode": "ORA_LOY_EXPIRED",
"ProdId": 999994000663205,
"CreatedBy": "LOYALTY_MARKETING_MANAGER",
"CreationDate": "2018-03-13T07:30:23.710+00:00",
"LastUpdatedBy": "LOYALTY_MARKETING_MANAGER",
"LastUpdateDate": "2018-03-13T07:30:48.066+00:00",
"LastUpdateLogin": "67462679F2B4419CE0534280F50AA31B",
"ExternalTransaction": "N",
"QualifyingPointUsed": "N",
"StatusCode": "ORA_TXN_STAT_PROCESSED",
"TypeCode": "ORA_TXN_ACC",
"SubTypeCode": "ORA_ACC_PROD",
"TransactionNumber": "300100148448790",
"UnaccMinor": "N",
"ApproveDt": null,
"CurcyExchDt": null,
"EndDt": null,
"ExpireInDays": null,
"InternalFlightDt": null,
"LoanBalance": null,
"LoanRepaymentDt": null,
"Points": 23,
"OptyCost": null,
"PostDt": null,
"PtnrProcDt": null,
"StartDt": "2018-03-13T07:30:24.405+00:00",
"SubmitDt": null,
"TransactionDate": "2018-03-13T07:30:24.405+00:00",
"BookClassCode": null,
"CancelledTransactionId": null,
"Comments": null,
"CurcyCode": "USD",
"DestAirportCode": null,
"DestZoneCode": null,
"DocumentNumber": null,
"ExternalReservationNumber": null,
"FareBasis": null,
"FareBasisCode": null,
"FareTypeCode": null,
"FlightNumber": null,
"FltTypeCode": null,
"GdsRecLocator": null,
"IntegrationId": null,
"InternalDest": null,
"InternalOrigin": null,
"ItemNumber": null,
"LocationCode": null,
"OrigAirportCode": null,
"OrigOrderId": null,
"OrigZoneCode": null,
"OwnerId": null,
"PartitionName": null,
"ParentTransactionId": null,
"PnrName": null,
"ProcessingComment": null,
"ProcessingLog": "Assigned Points: 43.0 Beans, Expiry Date: Mon Oct 01 23:59:59 UTC 2018 ()<br>Assigned Product Voucher: 1 Pro 500, Expiry Date: Tue Mar 13 07:30:24 UTC 2018 ()<br>",
"PtnrStatusCode": null,
"SubStatusCode": "ORA_TXN_SUB_STAT_SUCCESS",
"TicketNumber": null,
"TrvClassCode": null,
"TransactionChannelCode": "ORA_TXN_CHANNEL_MSR",
"AmountValue": 43,
"BookingDt": null,
"CancReasonCode": null,
"CorporateReferenceNumber": null,
"MarketingFlightNumber": null,
"OrderNumber": null,
"OrigOrdItmId": null,
"OrigPoints": null,
"OvrDupCheck": "N",
"PriceOverriden": "N",
"PackageCode": null,
"PymtTypeCode": null,
"RedemptionQuantityUOMCode": null,
"RefundPct": null,
"RfndOvrdCmnts": null,
"RfndOvrdRsnCode": null,
"SourceCode": null,
"ToMemberNumber": null,
"TotalLines": null,
"TrvlDistance": null,
"TransactionSourceCode": null,
"PeriodTypeCode": null,
"ReasonCode": null,
"ChildTransactionId": null,
"PeriodDurCode": null,
"ActivityDay": null,
"ActivityHour": null,
"ValStatusCode": null,
"DestCityCode": null,
"OriginCityCode": null,
"IncentivChoice": null,
"SmActionTypeCode": null,
"InvOrgId": 204,
"LineItemNumber": null,
"PnrNumber": null,
"ActivityDate": "2018-03-13T07:30:24.405+00:00",
"CorpCurrencyCode": "USD",
"CurcyConvRateType": "Corporate",
"ExternalProductName": null,
"ExternalProductType": null,
"ExternalProductLine": null,
"TotalDays": null,
"AccrualDisputeStatusCode": null,
"AccrualDisputeTypeCode": null,
"AccrualedValue": 43,
"ProgramNumber": "CDRM_10",
"ProgramName": "BIQA_LOYALTY_Starbucks",
"PartyName": "Stryker Corp.",
"PartyId": 100000016934002,
"ProductName": "Pro 400",
"InventoryItemId": 999994000663205,
"OrganizationId": 204,
"StatusMeaning": "Processed",
"RedemptionProgPointBlockId": null,
"RedemptionTotalPoints": null,
"RedemptionPointBlockNumber": null,
"RedemptionLoyPromoId": null,
"RedemptionPromotionName": null,
"TypeMeaning": "Accrual",
"SubTypeMeaning": "Product",
"TransactionEO_Test_c": null,
"TransactionEO_Update_c": null,
"TransactionEO_TXN_TEXT_c": null,
"TransactionEO_TXN_NUM_c": null,
"TransactionEO_TXN_DATE_c": null,
"TransactionEO_TXN_CB_c": null,
"TransactionEO_TXN_PER_c": null,
"TransactionEO_TXN_DT_c": null,
"TransactionEO_TXN_CURR_c": null,
"TransactionEO_TXN_FCL_c": null,
"TransactionEO_TXN_FOR_c": 100,
"TransactionEO_TXN_RT_c": null,
"links": [
{
"rel": "self",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100148448790",
"name": "activities",
"kind": "item"
},
{
"rel": "canonical",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100148448790",
"name": "activities",
"kind": "item"
},
{
"rel": "parent",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832",
"name": "loyMembers",
"kind": "item"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100148448790/lov/TransactionEO_LOVVA_For_TXN_FCL_c",
"name": "TransactionEO_LOVVA_For_TXN_FCL_c",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100148448790/lov/TransactionEO_LOVVA_For_TXN_RT_c",
"name": "TransactionEO_LOVVA_For_TXN_RT_c",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100148448790/lov/TransactionEO_LOVVA_For_TXN_CB_c",
"name": "TransactionEO_LOVVA_For_TXN_CB_c",
"kind": "collection"
},
{
"rel": "enclosure",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100148448790/enclosure/TransactionEO_TXN_LT_c",
"name": "TransactionEO_TXN_LT_c",
"kind": "other"
}
]
},
{
"LoyTransactionId": 300100148448788,
"ProcessDt": "2018-03-13T07:29:55.813+00:00",
"AccrualProgPointBlockId": null,
"AccrualTotalPoints": null,
"AccrualPromotionName": null,
"AccrualLoyPromoId": null,
"AccrualPointBlockNumber": null,
"RedemptionValue": 22,
"LoyRdmItmId": 300100148448789,
"LoyAcrlItmId": null,
"AcrlTransactionId": null,
"AcrlStatusCode": null,
"ProdId": 999994000663204,
"CreatedBy": "LOYALTY_MARKETING_MANAGER",
"CreationDate": "2018-03-13T07:29:33+00:00",
"LastUpdatedBy": "LOYALTY_MARKETING_MANAGER",
"LastUpdateDate": "2018-03-13T07:29:55.102+00:00",
"LastUpdateLogin": "67462679F2B4419CE0534280F50AA31B",
"ExternalTransaction": "N",
"QualifyingPointUsed": "N",
"StatusCode": "ORA_TXN_STAT_PROCESSED",
"TypeCode": "ORA_TXN_RED",
"SubTypeCode": "ORA_RED_PROD",
"TransactionNumber": "300100148448788",
"UnaccMinor": "N",
"ApproveDt": null,
"CurcyExchDt": null,
"EndDt": null,
"ExpireInDays": null,
"InternalFlightDt": null,
"LoanBalance": null,
"LoanRepaymentDt": null,
"Points": 22,
"OptyCost": null,
"PostDt": null,
"PtnrProcDt": null,
"StartDt": "2018-03-13T07:29:33.696+00:00",
"SubmitDt": null,
"TransactionDate": "2018-03-13T07:29:33.696+00:00",
"BookClassCode": null,
"CancelledTransactionId": null,
"Comments": null,
"CurcyCode": "USD",
"DestAirportCode": null,
"DestZoneCode": null,
"DocumentNumber": null,
"ExternalReservationNumber": null,
"FareBasis": null,
"FareBasisCode": null,
"FareTypeCode": null,
"FlightNumber": null,
"FltTypeCode": null,
"GdsRecLocator": null,
"IntegrationId": null,
"InternalDest": null,
"InternalOrigin": null,
"ItemNumber": null,
"LocationCode": null,
"OrigAirportCode": null,
"OrigOrderId": null,
"OrigZoneCode": null,
"OwnerId": null,
"PartitionName": null,
"ParentTransactionId": null,
"PnrName": null,
"ProcessingComment": null,
"ProcessingLog": "Redeemed Points: 22.0 Beans| ()<br>",
"PtnrStatusCode": null,
"SubStatusCode": "ORA_TXN_SUB_STAT_SUCCESS",
"TicketNumber": null,
"TrvClassCode": null,
"TransactionChannelCode": "ORA_TXN_CHANNEL_MSR",
"AmountValue": 12,
"BookingDt": null,
"CancReasonCode": null,
"CorporateReferenceNumber": null,
"MarketingFlightNumber": null,
"OrderNumber": null,
"OrigOrdItmId": null,
"OrigPoints": null,
"OvrDupCheck": "N",
"PriceOverriden": "N",
"PackageCode": null,
"PymtTypeCode": null,
"RedemptionQuantityUOMCode": null,
"RefundPct": null,
"RfndOvrdCmnts": null,
"RfndOvrdRsnCode": null,
"SourceCode": null,
"ToMemberNumber": null,
"TotalLines": null,
"TrvlDistance": null,
"TransactionSourceCode": null,
"PeriodTypeCode": null,
"ReasonCode": null,
"ChildTransactionId": null,
"PeriodDurCode": null,
"ActivityDay": null,
"ActivityHour": null,
"ValStatusCode": null,
"DestCityCode": null,
"OriginCityCode": null,
"IncentivChoice": null,
"SmActionTypeCode": null,
"InvOrgId": 204,
"LineItemNumber": null,
"PnrNumber": null,
"ActivityDate": "2018-03-13T07:29:33.696+00:00",
"CorpCurrencyCode": "USD",
"CurcyConvRateType": "Corporate",
"ExternalProductName": null,
"ExternalProductType": null,
"ExternalProductLine": null,
"TotalDays": null,
"AccrualDisputeStatusCode": null,
"AccrualDisputeTypeCode": null,
"AccrualedValue": null,
"ProgramNumber": "CDRM_10",
"ProgramName": "BIQA_LOYALTY_Starbucks",
"PartyName": "Stryker Corp.",
"PartyId": 100000016934002,
"ProductName": "Pro 500",
"InventoryItemId": 999994000663204,
"OrganizationId": 204,
"StatusMeaning": "Processed",
"RedemptionProgPointBlockId": null,
"RedemptionTotalPoints": null,
"RedemptionPointBlockNumber": null,
"RedemptionLoyPromoId": 300100126038724,
"RedemptionPromotionName": "BIQA_LOYALTY_REDEMPTION_PROMOTION",
"TypeMeaning": "Redemption",
"SubTypeMeaning": "Product",
"TransactionEO_Test_c": null,
"TransactionEO_Update_c": null,
"TransactionEO_TXN_TEXT_c": null,
"TransactionEO_TXN_NUM_c": null,
"TransactionEO_TXN_DATE_c": null,
"TransactionEO_TXN_CB_c": null,
"TransactionEO_TXN_PER_c": null,
"TransactionEO_TXN_DT_c": null,
"TransactionEO_TXN_CURR_c": null,
"TransactionEO_TXN_FCL_c": null,
"TransactionEO_TXN_FOR_c": 100,
"TransactionEO_TXN_RT_c": null,
"links": [
{
"rel": "self",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100148448788",
"name": "activities",
"kind": "item"
},
{
"rel": "canonical",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100148448788",
"name": "activities",
"kind": "item"
},
{
"rel": "parent",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832",
"name": "loyMembers",
"kind": "item"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100148448788/lov/TransactionEO_LOVVA_For_TXN_FCL_c",
"name": "TransactionEO_LOVVA_For_TXN_FCL_c",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100148448788/lov/TransactionEO_LOVVA_For_TXN_RT_c",
"name": "TransactionEO_LOVVA_For_TXN_RT_c",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100148448788/lov/TransactionEO_LOVVA_For_TXN_CB_c",
"name": "TransactionEO_LOVVA_For_TXN_CB_c",
"kind": "collection"
},
{
"rel": "enclosure",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100148448788/enclosure/TransactionEO_TXN_LT_c",
"name": "TransactionEO_TXN_LT_c",
"kind": "other"
}
]
},
{
"LoyTransactionId": 300100126038857,
"ProcessDt": "2018-01-12T10:29:10.715+00:00",
"AccrualProgPointBlockId": null,
"AccrualTotalPoints": null,
"AccrualPromotionName": "BIQA_LOYALTY_ENROLLMENT_PROMOTION",
"AccrualLoyPromoId": 300100126038721,
"AccrualPointBlockNumber": null,
"RedemptionValue": null,
"LoyRdmItmId": null,
"LoyAcrlItmId": 300100126038858,
"AcrlTransactionId": 300100126038857,
"AcrlStatusCode": "ORA_LOY_EXPIRED",
"ProdId": null,
"CreatedBy": "LOYALTY_PROGRAM_ADMINISTRATOR",
"CreationDate": "2018-01-12T10:29:09.116+00:00",
"LastUpdatedBy": "LOYALTY_PROGRAM_ADMINISTRATOR",
"LastUpdateDate": "2018-01-12T10:29:10.021+00:00",
"LastUpdateLogin": "628EC46635F9368AE0534280F50A06B6",
"ExternalTransaction": "N",
"QualifyingPointUsed": "N",
"StatusCode": "ORA_TXN_STAT_PROCESSED",
"TypeCode": "ORA_TXN_ACC",
"SubTypeCode": "ORA_ACC_ENR_BNS",
"TransactionNumber": "300100126038857",
"UnaccMinor": "N",
"ApproveDt": null,
"CurcyExchDt": null,
"EndDt": null,
"ExpireInDays": null,
"InternalFlightDt": null,
"LoanBalance": null,
"LoanRepaymentDt": null,
"Points": null,
"OptyCost": null,
"PostDt": null,
"PtnrProcDt": null,
"StartDt": "2018-01-12T10:29:09.926+00:00",
"SubmitDt": null,
"TransactionDate": "2018-01-12T10:29:09.926+00:00",
"BookClassCode": null,
"CancelledTransactionId": null,
"Comments": null,
"CurcyCode": "INR",
"DestAirportCode": null,
"DestZoneCode": null,
"DocumentNumber": null,
"ExternalReservationNumber": null,
"FareBasis": null,
"FareBasisCode": null,
"FareTypeCode": null,
"FlightNumber": null,
"FltTypeCode": null,
"GdsRecLocator": null,
"IntegrationId": null,
"InternalDest": null,
"InternalOrigin": null,
"ItemNumber": null,
"LocationCode": null,
"OrigAirportCode": null,
"OrigOrderId": null,
"OrigZoneCode": null,
"OwnerId": null,
"PartitionName": null,
"ParentTransactionId": null,
"PnrName": null,
"ProcessingComment": null,
"ProcessingLog": "Assigned Points: 200.0 Beans, Expiry Date: Wed Aug 01 23:59:59 UTC 2018 ()<br>",
"PtnrStatusCode": null,
"SubStatusCode": "ORA_TXN_SUB_STAT_SUCCESS",
"TicketNumber": null,
"TrvClassCode": null,
"TransactionChannelCode": null,
"AmountValue": null,
"BookingDt": null,
"CancReasonCode": null,
"CorporateReferenceNumber": null,
"MarketingFlightNumber": null,
"OrderNumber": null,
"OrigOrdItmId": null,
"OrigPoints": null,
"OvrDupCheck": "N",
"PriceOverriden": "N",
"PackageCode": null,
"PymtTypeCode": null,
"RedemptionQuantityUOMCode": null,
"RefundPct": null,
"RfndOvrdCmnts": null,
"RfndOvrdRsnCode": null,
"SourceCode": null,
"ToMemberNumber": null,
"TotalLines": null,
"TrvlDistance": null,
"TransactionSourceCode": null,
"PeriodTypeCode": null,
"ReasonCode": null,
"ChildTransactionId": null,
"PeriodDurCode": null,
"ActivityDay": null,
"ActivityHour": null,
"ValStatusCode": null,
"DestCityCode": null,
"OriginCityCode": null,
"IncentivChoice": null,
"SmActionTypeCode": null,
"InvOrgId": null,
"LineItemNumber": null,
"PnrNumber": null,
"ActivityDate": "2018-01-12T10:29:09.926+00:00",
"CorpCurrencyCode": "INR",
"CurcyConvRateType": "Corporate",
"ExternalProductName": null,
"ExternalProductType": null,
"ExternalProductLine": null,
"TotalDays": null,
"AccrualDisputeStatusCode": null,
"AccrualDisputeTypeCode": null,
"AccrualedValue": 200,
"ProgramNumber": "CDRM_10",
"ProgramName": "BIQA_LOYALTY_Starbucks",
"PartyName": null,
"PartyId": null,
"ProductName": null,
"InventoryItemId": null,
"OrganizationId": null,
"StatusMeaning": "Processed",
"RedemptionProgPointBlockId": null,
"RedemptionTotalPoints": null,
"RedemptionPointBlockNumber": null,
"RedemptionLoyPromoId": null,
"RedemptionPromotionName": null,
"TypeMeaning": "Accrual",
"SubTypeMeaning": "Enrollment Bonus",
"TransactionEO_Test_c": null,
"TransactionEO_Update_c": null,
"TransactionEO_TXN_TEXT_c": null,
"TransactionEO_TXN_NUM_c": null,
"TransactionEO_TXN_DATE_c": null,
"TransactionEO_TXN_CB_c": null,
"TransactionEO_TXN_PER_c": null,
"TransactionEO_TXN_DT_c": null,
"TransactionEO_TXN_CURR_c": null,
"TransactionEO_TXN_FCL_c": null,
"TransactionEO_TXN_FOR_c": 100,
"TransactionEO_TXN_RT_c": null,
"links": [
{
"rel": "self",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100126038857",
"name": "activities",
"kind": "item"
},
{
"rel": "canonical",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100126038857",
"name": "activities",
"kind": "item"
},
{
"rel": "parent",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832",
"name": "loyMembers",
"kind": "item"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100126038857/lov/TransactionEO_LOVVA_For_TXN_FCL_c",
"name": "TransactionEO_LOVVA_For_TXN_FCL_c",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100126038857/lov/TransactionEO_LOVVA_For_TXN_RT_c",
"name": "TransactionEO_LOVVA_For_TXN_RT_c",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100126038857/lov/TransactionEO_LOVVA_For_TXN_CB_c",
"name": "TransactionEO_LOVVA_For_TXN_CB_c",
"kind": "collection"
},
{
"rel": "enclosure",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100126038857/enclosure/TransactionEO_TXN_LT_c",
"name": "TransactionEO_TXN_LT_c",
"kind": "other"
}
]
}
],
"count": 4,
"hasMore": false,
"limit": 25,
"offset": 0,
"links": [
{
"rel": "self",
"href": "https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities",
"name": "activities",
"kind": "collection"
}
]
}
Example of Retrieving the Activity Details for a Specific Transaction
The following example shows you how to retrieve the activity details for a transaction for accrual transaction Id 300100148448790 under member Id 300100126038832.
Example URLThe following is an example of the resource URL.
GET
https://example.com:port/crmRestApi/resources/11.13.18.05/loyMembers/300100126038832/child/activities/300100148448790
Example Response
The following is an example of the response body.
{
"LoyTransactionId": 300100148448804,
"ProcessDt": "2018-03-13T07:34:47.301+00:00",
"AccrualProgPointBlockId": null,
"AccrualTotalPoints": null,
"AccrualPromotionName": "BIQA_LOYALTY_ACCRUAL_PROMOTION",
"AccrualLoyPromoId": 300100126038723,
"AccrualPointBlockNumber": null,
"RedemptionValue": null,
"LoyRdmItmId": null,
"LoyAcrlItmId": 300100148448805,
"AcrlTransactionId": 300100148448804,
"AcrlStatusCode": "ORA_LOY_EXPIRED",
"ProdId": 999994000663204,
"CreatedBy": "LOYALTY_MARKETING_MANAGER",
"CreationDate": "2018-03-13T07:34:14+00:00",
"LastUpdatedBy": "LOYALTY_MARKETING_MANAGER",
"LastUpdateDate": "2018-03-13T07:34:47.051+00:00",
"LastUpdateLogin": "67462679F2B4419CE0534280F50AA31B",
"ExternalTransaction": "N",
"QualifyingPointUsed": "N",
"StatusCode": "ORA_TXN_STAT_PROCESSED",
"TypeCode": "ORA_TXN_ACC",
"SubTypeCode": "ORA_ACC_PROD",
"TransactionNumber": "300100148448804",
"UnaccMinor": "N",
"ApproveDt": null,
"CurcyExchDt": null,
"EndDt": null,
"ExpireInDays": null,
"InternalFlightDt": null,
"LoanBalance": null,
"LoanRepaymentDt": null,
"Points": 500,
"OptyCost": null,
"PostDt": null,
"PtnrProcDt": null,
"StartDt": "2018-03-13T07:34:14.721+00:00",
"SubmitDt": null,
"TransactionDate": "2018-03-13T07:34:14.721+00:00",
"BookClassCode": null,
"CancelledTransactionId": null,
"Comments": null,
"CurcyCode": "USD",
"DestAirportCode": null,
"DestZoneCode": null,
"DocumentNumber": null,
"ExternalReservationNumber": null,
"FareBasis": null,
"FareBasisCode": null,
"FareTypeCode": null,
"FlightNumber": null,
"FltTypeCode": null,
"GdsRecLocator": null,
"IntegrationId": null,
"InternalDest": null,
"InternalOrigin": null,
"ItemNumber": null,
"LocationCode": null,
"OrigAirportCode": null,
"OrigOrderId": null,
"OrigZoneCode": null,
"OwnerId": null,
"PartitionName": null,
"ParentTransactionId": null,
"PnrName": null,
"ProcessingComment": null,
"ProcessingLog": "Assigned Points: 1200.0 Beans, Expiry Date: Mon Oct 01 23:59:59 UTC 2018 ()<br>Assigned Product Voucher: 1 Pro 500, Expiry Date: Tue Mar 13 07:34:14 UTC 2018 ()<br>",
"PtnrStatusCode": null,
"SubStatusCode": "ORA_TXN_SUB_STAT_SUCCESS",
"TicketNumber": null,
"TrvClassCode": null,
"TransactionChannelCode": null,
"AmountValue": 1200,
"BookingDt": null,
"CancReasonCode": null,
"CorporateReferenceNumber": null,
"MarketingFlightNumber": null,
"OrderNumber": null,
"OrigOrdItmId": null,
"OrigPoints": null,
"OvrDupCheck": "N",
"PriceOverriden": "N",
"PackageCode": null,
"PymtTypeCode": null,
"RedemptionQuantityUOMCode": null,
"RefundPct": null,
"RfndOvrdCmnts": null,
"RfndOvrdRsnCode": null,
"SourceCode": null,
"ToMemberNumber": null,
"TotalLines": null,
"TrvlDistance": null,
"TransactionSourceCode": null,
"PeriodTypeCode": null,
"ReasonCode": null,
"ChildTransactionId": null,
"PeriodDurCode": null,
"ActivityDay": null,
"ActivityHour": null,
"ValStatusCode": null,
"DestCityCode": null,
"OriginCityCode": null,
"IncentivChoice": null,
"SmActionTypeCode": null,
"InvOrgId": 204,
"LineItemNumber": null,
"PnrNumber": null,
"ActivityDate": "2018-03-13T07:34:14.721+00:00",
"CorpCurrencyCode": "USD",
"CurcyConvRateType": "Corporate",
"ExternalProductName": null,
"ExternalProductType": null,
"ExternalProductLine": null,
"TotalDays": null,
"AccrualDisputeStatusCode": null,
"AccrualDisputeTypeCode": null,
"AccrualedValue": 1200,
"ProgramNumber": "CDRM_10",
"ProgramName": "BIQA_LOYALTY_Starbucks",
"PartyName": "Stryker Corp.",
"PartyId": 100000016934002,
"ProductName": "Pro 500",
"InventoryItemId": 999994000663204,
"OrganizationId": 204,
"StatusMeaning": "Processed",
"RedemptionProgPointBlockId": null,
"RedemptionTotalPoints": null,
"RedemptionPointBlockNumber": null,
"RedemptionLoyPromoId": null,
"RedemptionPromotionName": null,
"TypeMeaning": "Accrual",
"SubTypeMeaning": "Product",
"TransactionEO_Test_c": null,
"TransactionEO_Update_c": null,
"TransactionEO_TXN_TEXT_c": null,
"TransactionEO_TXN_NUM_c": null,
"TransactionEO_TXN_DATE_c": null,
"TransactionEO_TXN_CB_c": null,
"TransactionEO_TXN_PER_c": null,
"TransactionEO_TXN_DT_c": null,
"TransactionEO_TXN_CURR_c": null,
"TransactionEO_TXN_FCL_c": null,
"TransactionEO_TXN_FOR_c": 100,
"TransactionEO_TXN_RT_c": null