Hello,
I’m trying to create a JSON that records at same time records for task, attachment and task_attachment table, I created a XML Map named C_INBOUND_TASK_COMERCIAL with all relations between these tables and alternative keys for each one, to run with perform_inbound_integration API. I’m using this JSON:
{
"parameters": {
"mapping_name": "C_INBOUND_TASK_COMERCIAL",
"xml_import": {
"inbound": {
"task": {
"user_def25": "070100049653", //alternate key
"task_type": "COMERCIAL",
"task_status": "OPEN",
"priority": "02",
"place_id_cust": "419",
"attachment": [
{
"attachment_name": "070100049653ATTACH1",
"attachment_type": "DOCUMENT",
"attachment_description": "arquivo teste 1", "attachment":"0x255044462D312E370A0A342030206F626A0A3C3C0A2F42697473506572436F6D706F6E656E7420380A2F436F6C6F725370616365202F4465766963655247420A2F46696C746572202F4443544465636F64650A2F486569676874203733360A2F4C656E677468203133313039330A2F53756274797065202F496D6167650A2F54797065202F58….",
"file_type": "application/pdf",
"task_attachment": [
{
"user_def1": "teste" //only to create the task_attachment record for the attachment record created, it's working
}
]
}
]
}
}
}
}
}
It’s working, inserting/updating records in the 3 tables, but there’s one problem, the attachment.attachment field is not being updated, always remaining null at the end. This field I belive receives a base64 code, but could someone who has already integrated the attachment table tell me the correct way to fill in this field?
Thanks