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