Send a new invoice data from Books to local certified solution via API json due local compliance
Greetings,
I hope you are doing well and staying safe.
Due to local compliance regulations, I am required to issue invoices exclusively using locally certified software, which Zoho Books is not. However, we would like to continue using Zoho Books, so we need to send invoice data to an external certified solution each time a new invoice is issued. This external system should automatically generate a corresponding invoice, essentially mirroring the one created in Zoho Books.
I have access to the API documentation for the external certified solution and have attempted to create a custom function to extract invoice data, format it in JSON, and send it to the external system. However, due to my limited knowledge, I have been unable to save the custom function successfully, as the Deluge editor consistently flags syntax errors.
The API documentation for the external solution can be found here: https://api.factplus.co.ao/documentation/
Below are some of the approaches I have attempted:
===
void EnviarFctraParaFctpls( Map invoice, Map organization, Map user )
{
// A função já recebe os detalhes da fatura e organização como 'invoice' e 'organization'
// Não precisamos usar zoho.books.getRecordsByID para os dados básicos da fatura.
// Usaremos 'invoice' diretamente.
// 1. Extrair Detalhes da Fatura (diretamente do 'invoice' Map)
invoiceData = invoice; // 'invoice' já é o mapa com os dados da fatura
organizationId = organization.get("organization_id"); // ID da sua organização no Zoho Books
invoiceNumber = invoiceData.get("invoice_number");
invoiceDate = invoiceData.get("date"); // Formato 'YYYY-MM-DD'
dueDate = invoiceData.get("due_date"); // Formato 'YYYY-MM-DD'
reference = invoiceData.get("reference_number"); // Pode usar o número de referência do Zoho Books
currency = invoiceData.get("currency_code");
// observation = invoiceData.get("notes"); // Supondo que 'notes' seja para observações
// ATENÇÃO: Verifique na documentação do Factplus como lidar com 'retention'.
// Se o Zoho Books não tiver um campo direto para 'retention', você pode precisar de lógica extra
// ou definir como "0" se não for aplicável no seu caso.
retention_value = "0";
// Dados do Cliente
customerData = invoiceData.get("customer_details");
clientName = customerData.get("customer_name");
clientNIF = customerData.get("vat_reg_no"); // Assumindo que NIF seja o VAT Registration Number
clientEmail = customerData.get("email");
clientCity = customerData.get("city");
clientAddress = customerData.get("billing_address").get("address"); // Endereço de fatura
clientPostalCode = customerData.get("billing_address").get("zip"); // CEP de fatura
clientCountry = customerData.get("billing_address").get("country"); // País de fatura
// Itens da Fatura
lineItems = invoiceData.get("line_items");
factplusItems = collection(); // Coleção para armazenar os itens formatados para o Factplus
for each item in lineItems
{
// Para itemcode, é ideal usar um ID que seja único e identificável no Factplus.
// item.get("item_id") é o ID interno do Zoho Books, o que pode não ser ideal se o Factplus
// espera um código de item de produto/serviço. Considere usar item.get("name") ou um campo personalizado.
itemCode = item.get("item_id");
description = item.get("description");
price = item.get("rate");
quantity = item.get("quantity");
taxRate = item.get("tax_percentage"); // Taxa de imposto
discount = item.get("discount"); // Desconto por linha de item
// ATENÇÃO: exemption_code e retention por item precisam ser verificados na API do Factplus.
exemptionCode = ""; // Valor padrão, ajuste se tiver campo correspondente
itemRetention = "0"; // Valor padrão, ajuste se tiver campo correspondente
factplusItem = Map();
factplusItem.put("itemcode", itemCode);
factplusItem.put("description", description);
factplusItem.put("price", price);
factplusItem.put("quantity", quantity);
factplusItem.put("tax", taxRate);
factplusItem.put("discount", discount);
factplusItem.put("exemption_code", exemptionCode);
factplusItem.put("retention", itemRetention);
factplusItems.add(factplusItem);
}
// 2. Construir o Objeto JSON para a API do Factplus
// ATENÇÃO: SUBSTITUA 'SUA_CHAVE_API_AQUI' PELA SUA CHAVE DE 32 DÍGITOS DO FACTPLUS
factplusPayload = Map();
factplusPayload.put("apicall", "CREATE");
factplusPayload.put("apikey", "SUA_CHAVE_API_AQUI"); // <-- SUA CHAVE API DO FACTPLUS AQUI!
documentMap = Map();
documentMap.put("type", "factura"); // Tipo de documento, confirme se "factura" é o correto
documentMap.put("date", invoiceDate);
documentMap.put("duedate", dueDate);
documentMap.put("vref", invoiceNumber); // Usando o número da fatura como referência. Verifique se o Factplus aceita este formato.
// A "serie" é crucial. O exemplo do Factplus mostra "2020". Você precisa definir uma série apropriada.
// Se o Zoho Books não tiver um campo para série, pode ser um valor fixo ou derivado.
documentMap.put("serie", "2024"); // <-- ATENÇÃO: Defina a série correta para o Factplus (ex: "2024", "FS_A")
documentMap.put("currency", currency);
documentMap.put("exchange_rate", "0"); // Ajuste se houver taxa de câmbio
// documentMap.put("observation", invoiceData.get("notes")); // Se usar campo de notas
documentMap.put("retention", retention_value);
clientMap = Map();
clientMap.put("name", clientName);
clientMap.put("nif", clientNIF);
clientMap.put("email", clientEmail);
clientMap.put("city", clientCity);
clientMap.put("address", clientAddress);
clientMap.put("postalcode", clientPostalCode);
clientMap.put("country", clientCountry);
factplusPayload.put("document", documentMap);
factplusPayload.put("client", clientMap);
factplusPayload.put("items", factplusItems);
// Converter o mapa Deluge para string JSON
jsonString = factplusPayload.toString();
// 3. Fazer a Chamada HTTP POST para a API do Factplus
// ATENÇÃO: Você PRECISA substituir "https://api.factplus.co.ao" pelo ENDPOINT COMPLETO
// da API do Factplus para a criação de faturas.
// Ex: "https://api.factplus.co.ao/v1/invoices" ou similar.
factplusAPI_URL = "https://api.factplus.co.ao"; // <-- SUBSTITUIR PELO ENDPOINT ESPECÍFICO DE CRIAÇÃO DE FATURA
// Cabeçalhos (Content-Type é essencial para JSON)
headers = Map();
headers.put("Content-Type", "application/json");
// Executar a chamada API
apiResponse = invokeurl
[
url : factplusAPI_URL
type : POST
headers: headers
content : jsonString
];
// 4. Tratar a Resposta da API
info "Request sent to Factplus: " + jsonString; // Para depuração, mostre o que foi enviado
info "Factplus API Response: " + apiResponse;
// Adicione lógica para verificar a resposta aqui.
// Ex: if (apiResponse.get("status") == "success") { ... }
// ou if (apiResponse.get("code") == 200) { ... }
// Logar erros se a resposta indicar falha e talvez enviar um email de alerta.
if (apiResponse.get("status") == "success") // Supondo que a API retorne um campo 'status'
{
info "Fatura enviada com sucesso para o Factplus!";
// Opcional: Atualizar a fatura no Zoho Books com um campo de status "Enviado para Factplus"
// Ou armazenar o ID de retorno do Factplus.
}
else
{
error "Erro ao enviar fatura para o Factplus: " + apiResponse.get("message"); // Supondo campo 'message'
// Opcional: Enviar email de erro para o cliente ou para o administrador
}
}
===
And
===
// Função para enviar fatura do Zoho Books para o Factplus
// Parâmetro: invoice_id (ID da fatura criada)
invoice_id = input.invoice_id;
// Obter detalhes da fatura do Zoho Books
invoice = zoho.books.getRecordsByID("Invoices", organization_id, invoice_id);
invoice_data = invoice.get("invoice");
// Mapear dados do cliente
customer_id = invoice_data.get("customer_id");
customer = zoho.books.getRecordsByID("Contacts", organization_id, customer_id);
customer_data = customer.get("contact");
client_map = Map();
client_map.put("name", customer_data.get("contact_name"));
client_map.put("nif", customer_data.get("tax_reg_no", ""));
client_map.put("email", customer_data.get("email", ""));
client_map.put("city", customer_data.get("billing_address").get("city", ""));
client_map.put("address", customer_data.get("billing_address").get("address", ""));
client_map.put("postalcode", customer_data.get("billing_address").get("zip", ""));
client_map.put("country", customer_data.get("billing_address").get("country", "Angola"));
// Mapear itens da fatura
items_list = List();
for each item in invoice_data.get("line_items")
{
item_map = Map();
item_map.put("itemcode", item.get("item_id", "ITEM" + item.get("line_item_id")));
item_map.put("description", item.get("name"));
item_map.put("price", item.get("rate").toString());
item_map.put("quantity", item.get("quantity").toString());
item_map.put("tax", "14"); // Ajuste conforme a tributação aplicável
item_map.put("discount", item.get("discount", "0").toString());
item_map.put("exemption_code", "");
item_map.put("retention", "");
item_map.put("unit", "Unidade");
items_list.add(item_map);
}
// Construir o corpo da requisição para o Factplus
payload = Map();
payload.put("apicall", "CREATE");
payload.put("apikey", "SUA_CHAVE_API_FACTPLUS"); // Substitua pela sua chave de API
document_map = Map();
document_map.put("type", "factura");
document_map.put("date", invoice_data.get("date"));
document_map.put("duedate", invoice_data.get("due_date"));
document_map.put("vref", invoice_data.get("invoice_number"));
document_map.put("serie", invoice_data.get("date").left(4)); // Ano da fatura
document_map.put("currency", "AOA");
document_map.put("exchange_rate", "0");
document_map.put("observation", "");
document_map.put("retention", "0");
payload.put("document", document_map);
payload.put("client", client_map);
payload.put("items", items_list);
// Enviar requisição para o Factplus
headers = Map();
headers.put("Content-Type", "application/json");
response = invokeurl
[
type: POST,
parameters: payload.toString(),
headers: headers,
connection: "FactplusAPI"
];
// Logar a resposta para depuração
info response;
===
Any help?
Thanks in advance.
Access your files securely from anywhere
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
ViSFe
Selina Peter
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Limitations on editing a message in Cliq
Hi I've checked the documentations and there's no mention of how many times a message can be edited. When trying with code, I get various numbers such as ~1000 edits or so. Please mention if there's a limit on how many times one can change a message viaemail address autocomplete
Is there a way to eliminate certain addresses from showing up in auto complete when entering an address? Many old and unused addresses currently show up, many of which I would like to get rid of. ThanksHow to use MAIL without Dashboard?
Whenever I open Mail, it opens Dashboard. This makes Mail area very small and also I cannot manage Folders (like delete/rename) etc. I want to know if there is any way to open only Mail apps and not the Dashboard.How can i download and secure all my mails from the archive folders?
Hi, i would like to download all my mails from my archive folders and secure it on my external HDD. Is this possible? Thx. amirHow to open filtered report in popup using Zoho Creator Deluge?
First report: There is so many records in Report, If I click one record, pop up is occur. Second report (Pop up): there is also so many record data, and this pop up is also Report, not Form. First report: It has got "Sales Order" field. when I click anyCan you default reports/charts to report the current week?
Our data table maintains two years of data. Management wants certain report to automatically filter the report to the latest calendar week. I know I can do this manually with filters but I want the report to automatically default to the latest calendarRendering PDF to view on page
My company upload lots of PDF files onto Zoho. But every time we open it, it downloads the file instead of viewing it on the web page. Does Zoho allow uploaded PDF files to be rendered to view on web page yet? I've been trying to use <embed> or <object> but it cannot be loaded. (similar thread: https://help.zoho.com/portal/community/topic/how-to-open-a-pdf-file-of-a-view-in-preview-mode)Overlapping Reports in Dashboards
It's rare, but occasionally it would be a good feature if I were able to overlap reports, either fully or partially in the Dashboards. Also, then having the ability to move objects to the front or rear, or make them transparent/translucent would be goodFeature request - pin or flag note
Hi, It would be great if you could either pin or flag one or more notes so that they remain visible when there are a bunch of notes and some get hidden in the list. Sometimes you are looking for a particular name that gets lost in a bunch of less importantAdmin guide: Handling Mailbox Settings for better user management
Managing day-to-day email scenarios, such as supporting users with multiple email addresses, ensuring uninterrupted email access during employee absences, enabling secure mailbox sharing, and enforcing organizational security and compliance, can be challengingCisco Webex Calling Intergration
Hi Guys, Our organisation is looking at a move from Salesforce to Zoho. We have found there is no support for Cisco Webex Calling however? Is there a way to enable this or are there any apps which can provide this? Thanks!Designing a practical Zoho setup for a small business: lessons from a real implementation
I recently finished setting up a Zoho-based operating system for a small but growing consumer beauty business (GlowAtHomeBeauty), and I wanted to share a practical takeaway for other founders and implementers. The business wasn’t failing because of lackDKIM (Marketing emails) UNVERIFIED (Zoho One)
I'm having a problem with Zoho One verifying my Marketing Email DKIM Record for MYFINISHERPHOTOS.COM. I have removed and re-entered the ownership, DKIM (Transactional emails), SPF and Marketing DKIM and all of them come back verified except the DKIM (MarketingZoho Recruit Community Meet-up - India
Namaste, India. 🙏🏼 The Zoho Recruit team is hitting the road—and we 're absolutely excited behind the scenes. Join us for the Zoho Recruit India Meet-up 2026, a morning designed to make your recruiting life easier (and a lot more effective). Date CityGenerate a Zoho Sign link
From time to time I get a response "I never received your you e-document for electronic signature" is there a way to generate a Zoho Sign link to share.Is it possible to create a word cloud chart in ZoHo Analystics?
Hi there, I have a volume of transaction text that I would like to analyse using word cloud (or other approcah to detect and present word frequency in a dataset). For example, I have 50,000 records describing menu items in restaurants. I want to be ableHow to Fix the Corrupted Outlook 2019 .pst file on Windows safely?
There are multiple reasons to get corrupted PST files (due to a power failure, system crash, or forced shutdown) and several other reasons. If You are using this ScanePST.EXE Microsoft inbuilt recovery tool, it only supports the minor corruption issue[Webinar] A recap of Zoho Writer in 2025
Hi Zoho Writer users, We're excited to announce Zoho Writer's webinar for January 2026: A recap of Zoho Writer in 2025. This webinar will provide a recap of the features and enhancements we added in 2025 to enhance your productivity. Choose your preferredHow to drag row(s) or column(s)?
Hi. Selecting a row or column and then dragging it to a new position does not seem to work. Am i missing something or this is just not possible in Zoho Sheet? Cheers, JayBuilding Toppings #5 - Creating and configuring custom service connections in Bigin Toppings
Hello Biginners, Integrating Bigin with external applications extends its capabilities and enables customized functionalities. In our last post, we saw how to create a default service connection. Today, we'll see how to create a custom service connectionAdmin asked me for Backend Details when I wanted to verify my ZeptoMail Account
Please provide the backend details where you will be adding the SMTP/API information of ZeptoMail Who knows what this means?Optimising CRM-Projects workflows to manage requests, using Forms as an intermediary
Is it possible to create a workflow between three apps with traceability between them all? We send information from Zoho CRM Deals over to Zoho Projects for project management and execution. We have used a lookup of sorts to create tasks in the past,Marketing Tip #15: Rank better with keyword-rich URLs for product pages
Your product page URL is a small detail that can make a surprisingly big difference. Clean, readable URLs help in two ways: They’re easier for customers to trust and remember (no one likes clicking a link that looks messy or random). They help searchConditional fields when converting a Lead and creating a Deal
Hi, On my Deal page I have a field which has a rule against it. Depending on the value entered, depends on which further fields are displayed. When I convert a Lead and select for a Deal to be created as well, all fields are shown, regardless of the valueATE Session on Payment Gateways: Our experts are live now. Post your questions now!
Hello everyone, Our experts are all excited to answer all your questions related to payment workflows. Please feel free to join this session and learn more about this topic. If you have a query at anytime, please post them here.Upload data deleted all Zoho form data that we manage
Good morning. Let me introduce myself, I'm Iky from Indonesia. I'm experiencing an error or problem using Zoho Forms. I manage Zoho Forms, but I previously encountered an error when I misclicked the delete button in the upload format. It apparently deletedZOHO FORMにURL表示ができない
初心者です。 ZOHO FORM で宿泊者名簿を作っています。 ゲストが、URLをクリックするとStripeで支払いができるようにURLを表示をしたいのですが、 上手くできません。 やり方が分かる方、ぜひ教えてください。Custom module - change from autonumber to name
I fear I know the answer to this already, but thought I'd ask the question. I created a custom module and instead of having a name as being the primary field, I changed it to an auto-number. I didn't realise that all searches would only show this reference.No Automatic Spacing on the Notebook App?
When I'm adding to notes on the app, I have to add spaces between words myself, rather than it automatically doing it. All my other apps add spacing, so it must be something with Zoho. Is there a setting I need to change, or something else I can do soHolidays - Cannot Enter Two Holidays on Same Day
I have a fairly common setup, where part-time employees receive 1/2 day's pay on a holiday and full-time employees receive a full day's pay. Historically, I've been able to accommodate this by entering two separate holidays, one that covers full-timeZoho Bookings and Survey Integration through Flow
I am trying to set up flows where once an appointment is marked as completed in Zoho Bookings, the applicable survey form would be sent to the customer. Problem is, I cannot customise flows wherein if Consultation A is completed, Survey Form A would beCampaigns set up and execution assistance
Hello Community, Can someone recommend a professional who can assist with the completion of my set up and deployment of Campaigns? Looking for a person or company that is not going to ask for big dollars up-front without a guarantee of performance toZobot with Plugs
Hello, I am having a problem with Zobot using Plugs. Here is my current flow: When I run the flow, I should immediately see the messages from the initial cards (Send Message cards), then after running the plug, and finally, see the messages after theKaizen #223 - File Manager in CRM Widget Using ZRC Methods
Hello, CRM Wizards! Here is what we are improving this week with Kaizen. we will explore the new ZRC (Zoho Request Client) introduced in Widget SDK v1.5, and learn how to use it to build a Related List Widget that integrates with Zoho WorkDrive. It helpsRemove Powered by Zoho at the footer
Hi, I've read two past tickets regarding this but it seems that the instructions given are outdated. I assume the layout keeps on changing, which makes it frustrating for me to search high and low. Please let me know how exactly do I do this now? ThError AS101 when adding new email alias
Hi, I am trying to add apple@(mydomain).com The error AS101 is shown while I try to add the alias.No Need To Fix Something That Is Working
Zoho Books is a great financial tool which helps businesses to become more efficient and productive with day-to-day operations. As such, every change, upgrade, improvement needs to be carefully thought before implemented in the software and I'm sure ZohoUsing email "importance" as workflow-criteria
I'd like to set up a workflow that triggers if an incoming email has been flagged as "high importance" but I'm not seeing any way to do that. Hopefully I'm just missing something obvious...?This domain is not allowed to add. Please contact support-as@zohocorp.com for further details
I am trying to setup the free version of Zoho Mail. When I tried to add my domain, theselfreunion.com I got the error message that is the subject of this Topic. I've read your other community forum topics, and this is NOT a free domain. So what is theWhat is Resolution Time in Business Hours
HI, What is the formula used to find the total time spent by an agent on a particular ticket? How is Resolution Time in Business Hours calculated in Zohodesk? As we need to find out the time spent on the ticket's solution by an agent we seek your assistanceNext Page