Odoo v12 API get invoice PDF

Question

This question got me started with my C# Odoo API implementation. I have working code using CookComputing.XmlRpcV2 to retrieve a list of invoices.

What I would like to implement is the option to retrieve/download a PDF of a selected invoice. Does anybody know what I would need to get this done?

When I search, I find forum posts stating reporting doesn't work since V11, such as this one. Neither do I see it mentioned in the online documentation for V12, although there is mention of it at the bottom of the page for V10.

Update

Someone mentioned to construct an URL:

http://localhost:8069/my/invoices/1?report_type=pdf&download=true&access_token=<ACCESSTOKEN>

Where 1 is the invoice ID. Technically this works, but requires me to be logged in to the portal using the browser. Even if I can log into the portal from my C# service, I do not know where/how to retrieve the correct access token. I can see this is in GUID form. Does anybody know whether this is the same token I could retrieve from the OAuth2 REST API (which is a paid module b.t.w.)?

Paul von Hoesslin · Accepted Answer · 2019-09-05T11:14:13.213

Correct. You can download the PDF by placing in the access_token.

This is the only way I managed to figure it out for Odoo v.12. after smashing my head against a brick wall repeatedly. My example programming language is with Python 3 though, not C#, but I'm sure you can adapt it.

odoo_url_host = "https://company.odoo.com"

The access_token can be found in the invoice's JSON response.

invoice_id = 1234
models = xmlrpcclient.ServerProxy('{}/xmlrpc/2/object'.format(odoo_url_host))
invoice = models.execute_kw(db, uid, password, "account.invoice", read, [[invoice_id]])

which, provided you get back a found invoice, you can use the response like so:

print(invoice["access_token"])

download_url = "%s/%s/my/invoices/%d?report_type=pdf&download=true&access_token=%s" % (odoo_url_host, invoice_id, invoice["access_token"])

Which if you simply want to automatically download, can be done like so:

import urllib.request

pdf_destination = "./invoices/invoice-%d.pdf" % invoice_id

urllib.request.urlretrieve(download_url, pdf_destination)

You'd need to change the way this is written for Python 2.7.

Also, make sure that you click 'share' on the invoice (within odoo) as sometimes the access_token doesn't get generated for that invoice and returns false otherwise.

Or if you'd like to seamlessly have the access_token generated, execute this before trying to get the access token:

ctx = {'active_model': 'account.invoice', 'active_id': invoice_id}
print(models.execute_kw(db, uid, password, 'portal.share', 'default_get',[{}],{'context': ctx}))

That should get you the share_link for the entire document, but all you need is the access_token to be generated. You can extract the access_token from the share_link value in the JSON response, if you'd like to do it that way. Anyway :) Happy coding.

Any idea how this could be done for ir.attachments ? I am able to construct url the attachment way, but access_token does not seem to work, however urls without access_token work fine in browser when logged in. Tried to call the `portal.share` with `ir.attachment` as ctx but get response ` \'ir.attachment\' object has no attribute \'get_base_url\'` — ladrua, Sep 23 '20 at 12:36

score 1 · Answer 2 · answered Jan 30 '19 at 13:17

1

I would try to use /xmlrpc/2/object with model ir.actions.report and method render_qweb_pdf. Bear in mind that you'll need a ir.actions.report record, because render_qweb_pdf isn't a "model method" (in OOP class method).

answered Jan 30 '19 at 13:17

CZoellner

13,553
3
25
38

How would I create an `ir.actions.report` record? – pritaeas Jan 31 '19 at 08:15
You don't have to create them, there already is one for invoices. – CZoellner Jan 31 '19 at 10:52

score 1 · Answer 3 · answered Feb 10 '20 at 18:30

I am currently testing a similar functionality but with stock.picking where I need delivery form downloaded from a remote Odoo instance and saved as an attachment in another instance. What I did is adding this function to stock.picking in remote Odoo.

@api.model
def sd_get_delivery_form(self, uid):
    picking = self.env['stock.picking'].sudo().search([('sd_uid', 'like', uid)], limit=1)
    if picking and picking.sale_id:
        pdf = self.env.ref('sale.action_report_saleorder').sudo().render_qweb_pdf([picking.sale_id.id])
        b64_pdf = base64.b64encode(pdf[0])
        order_pdf = b64_pdf.decode('utf-8')
        return {'file': order_pdf}
    else:
        return False

Then calling it using xmlrpc and save it as an attachment

attachment_name = "delivery_order_({})".format(self.id)
self.env['ir.attachment'].create({
    'name': attachment_name,
    'type': 'binary',
    'datas': dt['file'],
    'datas_fname': attachment_name + '.pdf',
    'store_fname': attachment_name,
    'res_model': self._name,
    'res_id': self.id,
    'mimetype': 'application/x-pdf'
})

What you can do in C# is getting the base64 and save it as PDF if you like to go in this similar way.

Thanks for this, but unfortunately I have no control over the remote Odoo setup/installation. — pritaeas, Feb 11 '20 at 09:35

score 0 · Answer 4 · answered Feb 10 '20 at 10:12

0

The simplest way is to use OdooRPC library : https://pythonhosted.org/OdooRPC/ref_report.html

answered Feb 10 '20 at 10:12

Quentin THEURET

1,222
6
12

Thanks, but I'm using C#, not Python. – pritaeas Feb 10 '20 at 12:23

Odoo v12 API get invoice PDF

Update

4 Answers4