Discussions
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Inbound template json
Hi all, I have in Netsuite an inbound e-document template json format for mapping a xml file, but it does not working.
Does anybody know how to map xml with json dynamically?
I am taking a sample from Netsuite.
{
"tranid": "${XML.Invoice.InvoiceHeader.InvoiceNumber}",
"trandate": "${XML.Invoice.InvoiceHeader.InvoiceDate}",
"currency": "${XML.Invoice.InvoiceHeader.Currency}",
"memo": "${XML.Invoice.InvoiceHeader.Memo}",
"createdfrom": "${XML.Invoice.InvoiceHeader.PONumber}",
"item":[
<#list XML.Invoice.InvoiceDetails.InvoiceItem as item>
{
"vendorcode": "${item.ItemName}",
"quantity": "${item.Quantity}",
"rate": "${item.UnitPrice?replace("$", "")}",
"amount": "${item.LineItemSubtotal?replace("$", "")}",
"description": "${item.Description}",
"tax1amt": "${item.TaxAmount?replace("$", "")}"
}
<#if item_has_next>,</#if>
</#list>