Adding a Passenger to a Communication Record
57 views
Skip to first unread message
Michael Gumtow
Apr 29, 2020, 5:44:03 PM4/29/20
to Trams API
Hi Dan,
I'm attempting to submit a profile update where I'm attaching a passenger number to a communication record, but the passenger number doesn't seem to be updating. I am able to update other communication field values without issue though.
In the sample request (attached below), I'm sending the passenger_LinkNo in the new comm insert data. After this update runs, and I pull the profile back the passenger number is not attached to the communication data.
Thanks in advance, and I would appreciate any insight you might be able to provide with this issue.
I'm submitting this update to the '/profile/applyupdates/' endpoint:
{
"SessionID": "{XXXXXXXXXXXXXXXXXXXXXXXXXXXXX}",
"deltaDataset": {
"profile": [
{
"update": {
"profileNo": {
"oldValue": 290949
},
"profileType_LinkCode": {
"oldValue": "I"
},
"name": {
"oldValue": "Fake/Test"
},
"interfaceID": {
"oldValue": "9007001234"
},
"title": {
"oldValue": ""
},
"businessType": {
"oldValue": ""
},
"firstName": {
"oldValue": "Test"
},
"lastName": {
"oldValue": "Fake"
},
"middleInit": {
"oldValue": ""
},
"courtesyTitle": {
"oldValue": ""
},
"modifyBy": {
"oldValue": "SYSDBA"
},
"modifyDateTime": {
"oldValue": "2020-04-29T14:36:00.357Z"
},
"creationDate": {
"oldValue": "2020-04-20T00:00:00.000Z"
},
"preferredVendor": {
"oldValue": "N"
},
"notes": {
"oldValue": ""
},
"additionalNotes": {
"oldValue": ""
},
"other": {
"oldValue": ""
},
"stmtRemarks": {
"oldValue": ""
},
"isActive": {
"oldValue": "Y"
},
"payeeName": {
"oldValue": ""
},
"outsideRate": {
"oldValue": 0
},
"unappliedBalance": {
"oldValue": 0
},
"salutation": {
"oldValue": ""
},
"primaryAgent_LinkNo": {
"oldValue": 1464
},
"vendorId": {
"oldValue": ""
},
"referredBy": {
"oldValue": "Fox Import"
},
"branch_LinkNo": {
"oldValue": 14
},
"agencyRemarks": {
"oldValue": "Online Lead Import from OneFox manual file upload."
},
"createBy": {
"oldValue": "OneFox Lead Import"
},
"webId": {
"oldValue": ""
},
"webPassword": {
"oldValue": ""
},
"misc1": {
"oldValue": ""
},
"misc2": {
"oldValue": ""
},
"CBNotesBlobType_LinkNo": {
"oldValue": 2
},
"additionalName": {
"oldValue": ""
},
"profileID": {
"oldValue": ""
},
"syncModDateTime": {
"oldValue": "2020-04-29T14:36:00.000Z"
},
"airlineNo": {
"oldValue": null
},
"GL_LinkNo": {
"oldValue": null
},
"travelPref": {
"oldValue": null
},
"serviceProviderOnly": {
"oldValue": null
},
"GL2_LinkNo": {
"oldValue": null
},
"GL2Rate": {
"oldValue": null
},
"creditLimit": {
"oldValue": null
},
"GLBranch_LinkNo": {
"oldValue": null
},
"checkRemarks": {
"oldValue": null
},
"altInterfaceID": {
"oldValue": null
},
"bankAccountNo": {
"oldValue": null
},
"bankRoutingNo": {
"oldValue": null
},
"CBPLookupItem_LinkNo": {
"oldValue": null
},
"miscEcoValue": {
"oldValue": null
},
"privLabel_LinkNo1": {
"oldValue": null
},
"seg_LinkNo1": {
"oldValue": null
},
"privLabel_LinkNo2": {
"oldValue": null
},
"seg_LinkNo2": {
"oldValue": null
},
"PCC": {
"oldValue": null
},
"SPUniqueID": {
"oldValue": null
},
"rate1": {
"oldValue": null
},
"CB_Notes": {
"oldValue": null
},
"address": [
{
"delete": {
"addressNo": 406483
}
},
{
"insert": {
"profile_LinkNo": 290949,
"address1": "123 Valley Rd",
"address2": "",
"city": "Richland Center",
"state": "WI",
"zip": "53924",
"country": "US",
"aptSuite": "",
"description": "",
"permitMarket": "Y",
"isValid": "Y",
"SPUniqueID": "",
"addressInstance": [
{
"insert": {
"addrType_LinkNo": 1,
"JAN1": null,
"FEB2": null,
"MAR3": null,
"APR4": null,
"MAY5": null,
"JUN6": null,
"JUL7": null,
"AUG8": null,
"SEP9": null,
"OCT10": null,
"NOV11": null,
"DEC12": null,
"SPUniqueID": ""
}
},
{
"insert": {
"addrType_LinkNo": 2,
"JAN1": null,
"FEB2": null,
"MAR3": null,
"APR4": null,
"MAY5": null,
"JUN6": null,
"JUL7": null,
"AUG8": null,
"SEP9": null,
"OCT10": null,
"NOV11": null,
"DEC12": null,
"SPUniqueID": ""
}
},
{
"insert": {
"addrType_LinkNo": 3,
"JAN1": null,
"FEB2": null,
"MAR3": null,
"APR4": null,
"MAY5": null,
"JUN6": null,
"JUL7": null,
"AUG8": null,
"SEP9": null,
"OCT10": null,
"NOV11": null,
"DEC12": null,
"SPUniqueID": ""
}
}
]
}
}
],
"comm": [
{
"delete": {
"commNo": 372076
}
},
{
"delete": {
"commNo": 372077
}
},
{
"insert": {
"profile_LinkNo": 290949,
"passenger_LinkNo": 330950,
"isPrimary": "Y",
"commType_LinkNo": 3,
"commValue": "fa...@test.com",
"description": "Email",
"permitMarket": "Y",
"sortNo": null,
"isValid": "Y",
"SOCMedSubType_LinkNo": null,
"SPUniqueID": null,
"travelerName": null,
"extraSortNo": null,
"isPrimPass": null
}
},
{
"insert": {
"profile_LinkNo": 290949,
"passenger_LinkNo": 330950,
"isPrimary": "Y",
"commType_LinkNo": 2,
"commValue": "9007001234",
"description": "Phone",
"permitMarket": "Y",
"sortNo": null,
"isValid": "Y",
"SOCMedSubType_LinkNo": null,
"SPUniqueID": null,
"travelerName": null,
"extraSortNo": null,
"isPrimPass": null
}
}
],
"profileMarketing": [
{
"delete": {
"profile_LinkNo": 290949
}
},
{
"insert": {
"profile_LinkNo": 290949,
"code_LinkNo": 13,
"checked": "Y",
"category_LinkNo": 25
}
}
],
"profMoreField": [
{
"delete": {
"profMoreFieldNo": 31858
}
},
{
"delete": {
"profMoreFieldNo": 31859
}
},
{
"insert": {
"profMoreFieldNo": 31858,
"moreFieldCat_LinkNo": 2,
"profile_LinkNo": 290949,
"fieldValue": "111111"
}
},
{
"insert": {
"profMoreFieldNo": 31859,
"moreFieldCat_LinkNo": 1,
"profile_LinkNo": 290949,
"fieldValue": "ECTST111"
}
}
]
}
}
]
}
}
Dan Palley
Apr 30, 2020, 12:08:12 PM4/30/20
to Trams API
Hi Mike,
Cards and communications can be linked to a profile or a passenger, but not both. For what you're trying to do, make sure PROFILE_LINKNO is NULL.
Dan
joel.l...@gmail.com
Sep 30, 2020, 4:11:07 PM9/30/20
to Trams API
I'm trying to get past a similar issue. Whenever I add comm or address to the passenger record, I get an error / invalid field response. Yet the passenger insert works well without mention of these fields.
deltadataset > Profile > Insert > passenger > insert > address / comm
I can add address and comm fields associated to Profiles, but if I insert the address or comm under the profile data section linked to a passenger:
deltadataset > profile > none > address / comm > insert >
'PROFILE_LINKNO' => null,
'passenger_LinkNo' => 1234,
'passenger_LinkNo' => 1234,
....
I get
'[FireDAC][Phys][IB]violation of FOREIGN KEY constraint "INTEG_220" on table "COMMUNICATION"'
Thanks
Joel
joel.l...@gmail.com
Oct 1, 2020, 10:27:19 AM10/1/20
to Trams API
I got past this issue, thanks
Reply all
Reply to author
Forward
0 new messages