I am trying to generate a journal from a custom function but it returns the following error:
Reviewing the documentation of the books apis, I am considering all the fields even if they are not required, then I leave my code in deluge with the call to the api that returns the error:
for each invoiceline in invoice.get("line_items")
{
MapaDiario = Map();
MapaDiarioLine = Map();
MapaDiarioLine1 = Map();
MapaDiarioTag = Map();
MapaDiarioTag1 = Map();
MapaDiarioCF = Map();
ListDiario = List();
if(invoiceline.get("project_id") != null && invoiceline.get("project_id") != "" && invoiceline.get("project_id") != "null")
{
MapaDiario.put("customer_id","1932335000007555077");
ResProj = zoho.books.getRecordsByID("Projects",organization.get("organization_id"),invoiceline.get("project_id"),"test_ih");
MapaDiario.put("reference_number",ResProj.get("project").get("customer_name") + " " + invoice.get("invoice_number"));
MapaDiario.put("notes",ResProj.get("project").get("customer_name") + " " + invoice.get("invoice_number"));
MapaDiario.put("journal_type","Both");
MapaDiario.put("currency_id",invoice.get("currency_id"));
MapaDiario.put("exchange_rate",invoice.get("exchange_rate"));
//Línea de diario para débito:
MapaDiarioLine.put("account_id","1932335000000034004");
MapaDiarioLine.put("customer_id",ResProj.get("project").get("customer_id"));
MapaDiarioLine.put("description",ResProj.get("project").get("customer_name") + " " + invoice.get("invoice_number"));
MapaDiarioLine.put("amount",invoiceline.get("item_total"));
MapaDiarioLine.put("debit_or_credit","debit");
MapaDiarioLine.put("project_id",ResProj.get("project").get("project_id"));
MapaDiarioTag.put("tag_id","");
MapaDiarioTag.put("tag_option_id","");
MapaDiarioLine.put("tags",MapaDiarioTag);
ListDiario.add(MapaDiarioLine);
//Línea de diario para crédito:
MapaDiarioLine1.put("account_id","1932335000000034004");
MapaDiarioLine1.put("customer_id",ResProj.get("project").get("customer_id"));
MapaDiarioLine1.put("description",ResProj.get("project").get("customer_name") + " " + invoice.get("invoice_number"));
MapaDiarioLine1.put("amount",invoiceline.get("item_total"));
MapaDiarioLine1.put("debit_or_credit","credit");
MapaDiarioLine1.put("project_id",ResProj.get("project").get("project_id"));
MapaDiarioTag1.put("tag_id","");
MapaDiarioTag1.put("tag_option_id","");
MapaDiarioLine1.put("tags",MapaDiarioTag1);
ListDiario.add(MapaDiarioLine1);
MapaDiario.put("line_items",ListDiario);
MapaDiario.put("status","draft");
MapaDiarioCF.put("customfield_id","");
MapaDiarioCF.put("value","");
MapaDiario.put("custom_fields",MapaDiarioCF);
info "Mapa: " + MapaDiario;
}
}
RespDiario = zoho.books.createRecord("journals",organization.get("organization_id"),MapaDiario,"test_ih");
info "Resp: " + RespDiario;
In the code infos I get the Map that I send in the api, which I see is well structured:
Could someone help me see what the error is, thank you very much in advance.
Greetings.