If the header of a CSV file contains dots, the key will be structured hierarchically.
Example:
Header 1;Header1.1;Header 1.2;Header 1.2.1;Header 2;Header 2.1
Value 1.1;Value 2.1;Value3.1;Value 4.1;Value 5.1;Value 6.1
Value 1.2;Value 2.2;Value 3.2;Value 4.2;Value 5.2;Value 6.2
{
"$trigger": {
"payload": {
"Header 1": [
null,
null,
[
null,
"Value 4.1"
]
],
"Header1": [
null,
"Value 2.1"
],
"Header 2": [
null,
"Value 6.1"
]
},
"event": "pv_purchase_order_item.items.create",
"collection": "pv_purchase_order_item"
}
Is it possible to interpret the dot as part of the string?
Expected:
{
"$trigger": {
"payload": {
"Header 1": "Value 1.1",
"Header 1.1": "Value 2.1",
"Header 1.2": "Value3.1",
"Header 1.2.1": "Value 4.1",
"Header 2": "Value 5.1",
"Header 2.1": "Value 6.1",
},
"event": "pv_purchase_order_item.items.create",
"collection": "pv_purchase_order_item"
}