Back to Collection Items
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @iTmp0 int
-- Important: Do not use nvarchar(max). See the warning about using nvarchar(max).
DECLARE @sTmp0 nvarchar(4000)
-- This example assumes the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
DECLARE @http int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Http', @http OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
DECLARE @success int
DECLARE @queryParams int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @queryParams OUT
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'memberId', ''
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'membershipNumber', ''
EXEC sp_OAMethod @queryParams, 'UpdateString', @success OUT, 'programCurrencyName', ''
-- Adds the "Authorization: Bearer <access_token>" header.
EXEC sp_OASetProperty @http, 'AuthToken', '<access_token>'
DECLARE @resp int
EXEC sp_OAMethod @http, 'QuickRequestParams', @resp OUT, 'GET', 'https://domain.com/services/data/v{{version}}/loyalty-programs/:loyaltyProgramName/members', @queryParams
EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
IF @iTmp0 = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @queryParams
RETURN
END
DECLARE @sbResponseBody int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.StringBuilder', @sbResponseBody OUT
EXEC sp_OAMethod @resp, 'GetBodySb', @success OUT, @sbResponseBody
DECLARE @jResp int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @jResp OUT
EXEC sp_OAMethod @jResp, 'LoadSb', @success OUT, @sbResponseBody
EXEC sp_OASetProperty @jResp, 'EmitCompact', 0
PRINT 'Response Body:'
EXEC sp_OAMethod @jResp, 'Emit', @sTmp0 OUT
PRINT @sTmp0
DECLARE @respStatusCode int
EXEC sp_OAGetProperty @resp, 'StatusCode', @respStatusCode OUT
PRINT 'Response Status Code = ' + @respStatusCode
IF @respStatusCode >= 400
BEGIN
PRINT 'Response Header:'
EXEC sp_OAGetProperty @resp, 'Header', @sTmp0 OUT
PRINT @sTmp0
PRINT 'Failed.'
EXEC @hr = sp_OADestroy @resp
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @queryParams
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jResp
RETURN
END
EXEC @hr = sp_OADestroy @resp
-- Sample JSON response:
-- (Sample code for parsing the JSON response is shown below)
-- {
-- "additionalLoyaltyProgramMemberFields": {},
-- "associatedAccount": null,
-- "associatedContact": {
-- "contactId": "003J8000002Yu0ZIAS",
-- "email": "ab@email.com",
-- "firstName": "Name1",
-- "lastName": "Name2"
-- },
-- "canReceivePartnerPromotions": true,
-- "canReceivePromotions": true,
-- "enrollmentChannel": "Email",
-- "enrollmentDate": "2021-01-01",
-- "groupCreatedByMember": null,
-- "groupName": null,
-- "lastActivityDate": null,
-- "loyaltyProgramMemberId": "0lMJ8000000CaRMMA0",
-- "loyaltyProgramName": "NTO Insider",
-- "memberCurrencies": [
-- {
-- "additionalLoyaltyMemberCurrencyFields": {
-- "Level_Before_Reset__c": null
-- },
-- "escrowPointsBalance": 0,
-- "expirablePoints": 0,
-- "lastAccrualProcessedDate": null,
-- "lastEscrowProcessedDate": null,
-- "lastExpirationProcessRunDate": null,
-- "lastPointsAggregationDate": null,
-- "lastPointsResetDate": null,
-- "loyaltyMemberCurrencyName": "NTO Qualifying Points",
-- "loyaltyProgramCurrencyId": "0lcJ8000000CaR7IAK",
-- "loyaltyProgramCurrencyName": null,
-- "memberCurrencyId": "0lzJ8000000CaRMIA0",
-- "nextQualifyingPointsResetDate": "2024-12-31",
-- "pointsBalance": 0,
-- "qualifyingPointsBalanceBeforeReset": 0,
-- "totalEscrowPointsAccrued": 0,
-- "totalEscrowRolloverPoints": 0,
-- "totalPointsAccrued": 0,
-- "totalPointsExpired": 0,
-- "totalPointsRedeemed": 0
-- }
-- ],
-- "memberStatus": "Active",
-- "memberTiers": [
-- {
-- "additionalLoyaltyMemberTierFields": {},
-- "areTierBenefitsAssigned": false,
-- "loyaltyMemberTierId": "0lyJ8000000CaRMIA0",
-- "loyaltyMemberTierName": "Bronze",
-- "tierChangeReason": null,
-- "tierChangeReasonType": null,
-- "tierEffectiveDate": "2021-01-01",
-- "tierExpirationDate": null,
-- "tierGroupId": "0ltJ8000000CaR8IAK",
-- "tierGroupName": null,
-- "tierId": "0lgJ80000008OI5IAM",
-- "tierSequenceNumber": 10
-- }
-- ],
-- "memberType": "Individual",
-- "membershipEndDate": "2022-01-01",
-- "membershipLastRenewalDate": null,
-- "membershipNumber": "Member1",
-- "referredBy": null,
-- "relatedCorporateMembershipNumber": null,
-- "transactionJournalStatementFrequency": "Monthly",
-- "transactionJournalStatementLastGeneratedDate": null,
-- "transactionJournalStatementMethod": "Mail"
-- }
-- Sample code for parsing the JSON response...
-- Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
DECLARE @Level_Before_Reset__c nvarchar(4000)
DECLARE @escrowPointsBalance int
DECLARE @expirablePoints int
DECLARE @lastAccrualProcessedDate nvarchar(4000)
DECLARE @lastEscrowProcessedDate nvarchar(4000)
DECLARE @lastExpirationProcessRunDate nvarchar(4000)
DECLARE @lastPointsAggregationDate nvarchar(4000)
DECLARE @lastPointsResetDate nvarchar(4000)
DECLARE @loyaltyMemberCurrencyName nvarchar(4000)
DECLARE @loyaltyProgramCurrencyId nvarchar(4000)
DECLARE @loyaltyProgramCurrencyName nvarchar(4000)
DECLARE @memberCurrencyId nvarchar(4000)
DECLARE @nextQualifyingPointsResetDate nvarchar(4000)
DECLARE @pointsBalance int
DECLARE @qualifyingPointsBalanceBeforeReset int
DECLARE @totalEscrowPointsAccrued int
DECLARE @totalEscrowRolloverPoints int
DECLARE @totalPointsAccrued int
DECLARE @totalPointsExpired int
DECLARE @totalPointsRedeemed int
DECLARE @areTierBenefitsAssigned int
DECLARE @loyaltyMemberTierId nvarchar(4000)
DECLARE @loyaltyMemberTierName nvarchar(4000)
DECLARE @tierChangeReason nvarchar(4000)
DECLARE @tierChangeReasonType nvarchar(4000)
DECLARE @tierEffectiveDate nvarchar(4000)
DECLARE @tierExpirationDate nvarchar(4000)
DECLARE @tierGroupId nvarchar(4000)
DECLARE @tierGroupName nvarchar(4000)
DECLARE @tierId nvarchar(4000)
DECLARE @tierSequenceNumber int
DECLARE @associatedAccount nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @associatedAccount OUT, 'associatedAccount'
DECLARE @ContactId nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @ContactId OUT, 'associatedContact.contactId'
DECLARE @v_Email nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @v_Email OUT, 'associatedContact.email'
DECLARE @FirstName nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @FirstName OUT, 'associatedContact.firstName'
DECLARE @LastName nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @LastName OUT, 'associatedContact.lastName'
DECLARE @canReceivePartnerPromotions int
EXEC sp_OAMethod @jResp, 'BoolOf', @canReceivePartnerPromotions OUT, 'canReceivePartnerPromotions'
DECLARE @canReceivePromotions int
EXEC sp_OAMethod @jResp, 'BoolOf', @canReceivePromotions OUT, 'canReceivePromotions'
DECLARE @enrollmentChannel nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @enrollmentChannel OUT, 'enrollmentChannel'
DECLARE @enrollmentDate nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @enrollmentDate OUT, 'enrollmentDate'
DECLARE @groupCreatedByMember nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @groupCreatedByMember OUT, 'groupCreatedByMember'
DECLARE @groupName nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @groupName OUT, 'groupName'
DECLARE @lastActivityDate nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @lastActivityDate OUT, 'lastActivityDate'
DECLARE @loyaltyProgramMemberId nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @loyaltyProgramMemberId OUT, 'loyaltyProgramMemberId'
DECLARE @loyaltyProgramName nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @loyaltyProgramName OUT, 'loyaltyProgramName'
DECLARE @memberStatus nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @memberStatus OUT, 'memberStatus'
DECLARE @memberType nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @memberType OUT, 'memberType'
DECLARE @membershipEndDate nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @membershipEndDate OUT, 'membershipEndDate'
DECLARE @membershipLastRenewalDate nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @membershipLastRenewalDate OUT, 'membershipLastRenewalDate'
DECLARE @membershipNumber nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @membershipNumber OUT, 'membershipNumber'
DECLARE @referredBy nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @referredBy OUT, 'referredBy'
DECLARE @relatedCorporateMembershipNumber nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @relatedCorporateMembershipNumber OUT, 'relatedCorporateMembershipNumber'
DECLARE @transactionJournalStatementFrequency nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @transactionJournalStatementFrequency OUT, 'transactionJournalStatementFrequency'
DECLARE @transactionJournalStatementLastGeneratedDate nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @transactionJournalStatementLastGeneratedDate OUT, 'transactionJournalStatementLastGeneratedDate'
DECLARE @transactionJournalStatementMethod nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @transactionJournalStatementMethod OUT, 'transactionJournalStatementMethod'
DECLARE @i int
SELECT @i = 0
DECLARE @count_i int
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'memberCurrencies'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'StringOf', @Level_Before_Reset__c OUT, 'memberCurrencies[i].additionalLoyaltyMemberCurrencyFields.Level_Before_Reset__c'
EXEC sp_OAMethod @jResp, 'IntOf', @escrowPointsBalance OUT, 'memberCurrencies[i].escrowPointsBalance'
EXEC sp_OAMethod @jResp, 'IntOf', @expirablePoints OUT, 'memberCurrencies[i].expirablePoints'
EXEC sp_OAMethod @jResp, 'StringOf', @lastAccrualProcessedDate OUT, 'memberCurrencies[i].lastAccrualProcessedDate'
EXEC sp_OAMethod @jResp, 'StringOf', @lastEscrowProcessedDate OUT, 'memberCurrencies[i].lastEscrowProcessedDate'
EXEC sp_OAMethod @jResp, 'StringOf', @lastExpirationProcessRunDate OUT, 'memberCurrencies[i].lastExpirationProcessRunDate'
EXEC sp_OAMethod @jResp, 'StringOf', @lastPointsAggregationDate OUT, 'memberCurrencies[i].lastPointsAggregationDate'
EXEC sp_OAMethod @jResp, 'StringOf', @lastPointsResetDate OUT, 'memberCurrencies[i].lastPointsResetDate'
EXEC sp_OAMethod @jResp, 'StringOf', @loyaltyMemberCurrencyName OUT, 'memberCurrencies[i].loyaltyMemberCurrencyName'
EXEC sp_OAMethod @jResp, 'StringOf', @loyaltyProgramCurrencyId OUT, 'memberCurrencies[i].loyaltyProgramCurrencyId'
EXEC sp_OAMethod @jResp, 'StringOf', @loyaltyProgramCurrencyName OUT, 'memberCurrencies[i].loyaltyProgramCurrencyName'
EXEC sp_OAMethod @jResp, 'StringOf', @memberCurrencyId OUT, 'memberCurrencies[i].memberCurrencyId'
EXEC sp_OAMethod @jResp, 'StringOf', @nextQualifyingPointsResetDate OUT, 'memberCurrencies[i].nextQualifyingPointsResetDate'
EXEC sp_OAMethod @jResp, 'IntOf', @pointsBalance OUT, 'memberCurrencies[i].pointsBalance'
EXEC sp_OAMethod @jResp, 'IntOf', @qualifyingPointsBalanceBeforeReset OUT, 'memberCurrencies[i].qualifyingPointsBalanceBeforeReset'
EXEC sp_OAMethod @jResp, 'IntOf', @totalEscrowPointsAccrued OUT, 'memberCurrencies[i].totalEscrowPointsAccrued'
EXEC sp_OAMethod @jResp, 'IntOf', @totalEscrowRolloverPoints OUT, 'memberCurrencies[i].totalEscrowRolloverPoints'
EXEC sp_OAMethod @jResp, 'IntOf', @totalPointsAccrued OUT, 'memberCurrencies[i].totalPointsAccrued'
EXEC sp_OAMethod @jResp, 'IntOf', @totalPointsExpired OUT, 'memberCurrencies[i].totalPointsExpired'
EXEC sp_OAMethod @jResp, 'IntOf', @totalPointsRedeemed OUT, 'memberCurrencies[i].totalPointsRedeemed'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'memberTiers'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'BoolOf', @areTierBenefitsAssigned OUT, 'memberTiers[i].areTierBenefitsAssigned'
EXEC sp_OAMethod @jResp, 'StringOf', @loyaltyMemberTierId OUT, 'memberTiers[i].loyaltyMemberTierId'
EXEC sp_OAMethod @jResp, 'StringOf', @loyaltyMemberTierName OUT, 'memberTiers[i].loyaltyMemberTierName'
EXEC sp_OAMethod @jResp, 'StringOf', @tierChangeReason OUT, 'memberTiers[i].tierChangeReason'
EXEC sp_OAMethod @jResp, 'StringOf', @tierChangeReasonType OUT, 'memberTiers[i].tierChangeReasonType'
EXEC sp_OAMethod @jResp, 'StringOf', @tierEffectiveDate OUT, 'memberTiers[i].tierEffectiveDate'
EXEC sp_OAMethod @jResp, 'StringOf', @tierExpirationDate OUT, 'memberTiers[i].tierExpirationDate'
EXEC sp_OAMethod @jResp, 'StringOf', @tierGroupId OUT, 'memberTiers[i].tierGroupId'
EXEC sp_OAMethod @jResp, 'StringOf', @tierGroupName OUT, 'memberTiers[i].tierGroupName'
EXEC sp_OAMethod @jResp, 'StringOf', @tierId OUT, 'memberTiers[i].tierId'
EXEC sp_OAMethod @jResp, 'IntOf', @tierSequenceNumber OUT, 'memberTiers[i].tierSequenceNumber'
SELECT @i = @i + 1
END
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @queryParams
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jResp
END
GO
Curl Command
curl -G -d "memberId="
-d "membershipNumber="
-d "programCurrencyName="
-H "Authorization: Bearer <access_token>"
https://domain.com/services/data/v{{version}}/loyalty-programs/:loyaltyProgramName/members
Postman Collection Item JSON
{
"name": "Member Profile",
"protocolProfileBehavior": {
"disableBodyPruning": true
},
"request": {
"method": "GET",
"header": [
],
"body": {
"mode": "raw",
"raw": "",
"options": {
"raw": {
"language": "json"
}
}
},
"url": {
"raw": "{{_endpoint}}/services/data/v{{version}}/loyalty-programs/:loyaltyProgramName/members?memberId=&membershipNumber=&programCurrencyName=",
"host": [
"{{_endpoint}}"
],
"path": [
"services",
"data",
"v{{version}}",
"loyalty-programs",
":loyaltyProgramName",
"members"
],
"query": [
{
"key": "memberId",
"value": "",
"description": "The ID of the loyalty program member."
},
{
"key": "membershipNumber",
"value": "",
"description": "The membership number of the loyalty program member."
},
{
"key": "programCurrencyName",
"value": "",
"description": "The name of the loyalty program currency associated with the member.\nUse this parameter to get the details of the member’s points-related information for a specific currency."
}
],
"variable": [
{
"key": "loyaltyProgramName",
"value": ""
}
]
},
"description": "Standard Documentation:\n\n[https://developer.salesforce.com/docs/atlas.en-us.loyalty.meta/loyalty/connect_resources_member_profile.htm](https://developer.salesforce.com/docs/atlas.en-us.loyalty.meta/loyalty/connect_resources_member_profile.htm)"
},
"response": [
{
"name": "Member Profile",
"originalRequest": {
"method": "GET",
"header": [
{
"key": "Authorization",
"value": "Bearer {{accessToken}}"
}
],
"body": {
"mode": "raw",
"raw": "",
"options": {
"raw": {
"language": "json"
}
}
},
"url": {
"raw": "{{_endpoint}}/services/data/v{{version}}/loyalty-programs/:loyaltyProgramName/members?memberId=0lMJ8000000CaRMMA0&membershipNumber=Member1&programCurrencyName=NTO Qualifying Points",
"host": [
"{{_endpoint}}"
],
"path": [
"services",
"data",
"v{{version}}",
"loyalty-programs",
":loyaltyProgramName",
"members"
],
"query": [
{
"key": "memberId",
"value": "0lMJ8000000CaRMMA0",
"description": "The ID of the loyalty program member."
},
{
"key": "membershipNumber",
"value": "Member1",
"description": "The membership number of the loyalty program member."
},
{
"key": "programCurrencyName",
"value": "NTO Qualifying Points",
"description": "The name of the loyalty program currency associated with the member.\nUse this parameter to get the details of the member’s points-related information for a specific currency."
}
],
"variable": [
{
"key": "loyaltyProgramName",
"value": "NTO Insider"
}
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Date",
"value": "Wed, 22 May 2024 16:16:23 GMT"
},
{
"key": "Strict-Transport-Security",
"value": "max-age=63072000; includeSubDomains"
},
{
"key": "X-Content-Type-Options",
"value": "nosniff"
},
{
"key": "X-Robots-Tag",
"value": "none"
},
{
"key": "Cache-Control",
"value": "no-cache,must-revalidate,max-age=0,no-store,private"
},
{
"key": "Content-Type",
"value": "application/json;charset=UTF-8"
},
{
"key": "Vary",
"value": "Accept-Encoding"
},
{
"key": "Content-Encoding",
"value": "gzip"
},
{
"key": "Transfer-Encoding",
"value": "chunked"
}
],
"cookie": [
],
"body": "{\n \"additionalLoyaltyProgramMemberFields\": {},\n \"associatedAccount\": null,\n \"associatedContact\": {\n \"contactId\": \"003J8000002Yu0ZIAS\",\n \"email\": \"ab@email.com\",\n \"firstName\": \"Name1\",\n \"lastName\": \"Name2\"\n },\n \"canReceivePartnerPromotions\": true,\n \"canReceivePromotions\": true,\n \"enrollmentChannel\": \"Email\",\n \"enrollmentDate\": \"2021-01-01\",\n \"groupCreatedByMember\": null,\n \"groupName\": null,\n \"lastActivityDate\": null,\n \"loyaltyProgramMemberId\": \"0lMJ8000000CaRMMA0\",\n \"loyaltyProgramName\": \"NTO Insider\",\n \"memberCurrencies\": [\n {\n \"additionalLoyaltyMemberCurrencyFields\": {\n \"Level_Before_Reset__c\": null\n },\n \"escrowPointsBalance\": 0,\n \"expirablePoints\": 0,\n \"lastAccrualProcessedDate\": null,\n \"lastEscrowProcessedDate\": null,\n \"lastExpirationProcessRunDate\": null,\n \"lastPointsAggregationDate\": null,\n \"lastPointsResetDate\": null,\n \"loyaltyMemberCurrencyName\": \"NTO Qualifying Points\",\n \"loyaltyProgramCurrencyId\": \"0lcJ8000000CaR7IAK\",\n \"loyaltyProgramCurrencyName\": null,\n \"memberCurrencyId\": \"0lzJ8000000CaRMIA0\",\n \"nextQualifyingPointsResetDate\": \"2024-12-31\",\n \"pointsBalance\": 0,\n \"qualifyingPointsBalanceBeforeReset\": 0,\n \"totalEscrowPointsAccrued\": 0,\n \"totalEscrowRolloverPoints\": 0,\n \"totalPointsAccrued\": 0,\n \"totalPointsExpired\": 0,\n \"totalPointsRedeemed\": 0\n }\n ],\n \"memberStatus\": \"Active\",\n \"memberTiers\": [\n {\n \"additionalLoyaltyMemberTierFields\": {},\n \"areTierBenefitsAssigned\": false,\n \"loyaltyMemberTierId\": \"0lyJ8000000CaRMIA0\",\n \"loyaltyMemberTierName\": \"Bronze\",\n \"tierChangeReason\": null,\n \"tierChangeReasonType\": null,\n \"tierEffectiveDate\": \"2021-01-01\",\n \"tierExpirationDate\": null,\n \"tierGroupId\": \"0ltJ8000000CaR8IAK\",\n \"tierGroupName\": null,\n \"tierId\": \"0lgJ80000008OI5IAM\",\n \"tierSequenceNumber\": 10\n }\n ],\n \"memberType\": \"Individual\",\n \"membershipEndDate\": \"2022-01-01\",\n \"membershipLastRenewalDate\": null,\n \"membershipNumber\": \"Member1\",\n \"referredBy\": null,\n \"relatedCorporateMembershipNumber\": null,\n \"transactionJournalStatementFrequency\": \"Monthly\",\n \"transactionJournalStatementLastGeneratedDate\": null,\n \"transactionJournalStatementMethod\": \"Mail\"\n}"
}
]
}