Connect Lexware Office and Looker

Both apps 72Lexware Office 50Looker 22

• Trigger
  Contact updated (instant)

  Fires when a contact changes in Lexware Office. Event type: contact.changed.

• Trigger
  Invoice status changed (instant)

  Fires when an invoice's status changes in Lexware Office. Event type: invoice.status.changed.

• Trigger
  New article (instant)

  Fires when a new article is created in Lexware Office. Event type: article.created.

• Trigger
  New contact (instant)

  Fires when a new contact is created in Lexware Office. Event type: contact.created.

• Trigger
  New credit note (instant)

  Fires when a new credit note is created in Lexware Office. Event type: credit-note.created.

• Trigger
  New invoice (instant)

  Fires when a new invoice is created in Lexware Office. Event type: invoice.created.

• Trigger
  New order confirmation (instant)

  Fires when a new order confirmation is created in Lexware Office. Event type: order-confirmation.created.

• Trigger
  New quotation (instant)

  Fires when a new quotation is created in Lexware Office. Event type: quotation.created.

• Trigger
  New voucher (instant)

  Fires when a new bookkeeping voucher is created in Lexware Office. Event type: voucher.created.

• Trigger
  Payment changed (instant)

  Fires when the payment status of a sales voucher changes in Lexware Office. Event type: payment.changed.

• Action
  Create a contact

  Creates a contact in Lexware Office as a person or a company, with optional billing address, email, phone and note, and returns the new contact's ID.

• Action
  Create a credit note

  Creates a credit note in Lexware Office for an existing contact or a typed-in address, with your line items. Saves it as a draft unless you choose to finalize it.

• Action
  Create a delivery note

  Creates a delivery note in Lexware Office for an existing contact or a typed-in address, with your delivered line items. Saves it as a draft unless you choose to finalize it.

• Action
  Create a dunning

  Creates a dunning (payment reminder) in Lexware Office, normally chasing an unpaid invoice. Saves it as a draft unless you choose to finalize it.

• Action
  Create an article

  Creates a product or service article in Lexware Office with its unit, price and tax rate, and returns the new article's ID.

• Action
  Create an invoice

  Creates an invoice in Lexware Office for an existing contact or a typed-in address, with your line items and payment terms. Saves it as a draft unless you choose to finalize it.

• Action
  Create an order confirmation

  Creates an order confirmation in Lexware Office for an existing contact or a typed-in address, with your confirmed line items. Saves it as a draft unless you choose to finalize it.

• Action
  Create a quotation

  Creates a quotation in Lexware Office for an existing contact or a typed-in address, with your quoted line items and an expiry date. Saves it as a draft unless you choose to finalize it.

• Action
  Create a voucher

  Books a voucher (an incoming or outgoing document) into Lexware Office with its booking lines, and returns the new voucher's ID.

• Action
  Delete an article

  Deletes an article from Lexware Office by its ID.

• Action
  Download a credit note file

  Returns the PDF file ID and download URL for a finalized credit note in Lexware Office.

• Action
  Download a delivery note file

  Returns the PDF file ID and download URL for a finalized delivery note in Lexware Office.

• Action
  Download a dunning file

  Returns the PDF file ID and download URL for a finalized dunning in Lexware Office.

• Action
  Download a file

  Downloads the actual bytes of a file stored in Lexware Office by its file ID — for example the PDF that "Download an invoice file" reports. Returns the file so a later step can email, upload or attach it.

• Action
  Download an invoice file

  Returns the PDF file ID and download URL for a finalized invoice in Lexware Office.

• Action
  Download an order confirmation file

  Returns the PDF file ID and download URL for a finalized order confirmation in Lexware Office.

• Action
  Download a quotation file

  Returns the PDF file ID and download URL for a finalized quotation in Lexware Office.

• Action
  Find articles

  Searches the Lexware Office article list by article number, barcode or type, and returns the matching articles a page at a time.

• Action
  Find contacts

  Searches Lexware Office contacts by email, name, number or role, and returns the matching contacts a page at a time.

• Action
  Find voucher list

  Lists Lexware Office documents (invoices, credit notes, quotations and the rest) filtered by type, status, contact and date, a page at a time.

• Action
  Find vouchers

  Finds booked vouchers in Lexware Office by their document number and returns the full voucher records.

• Action
  Get a contact

  Returns one Lexware Office contact by its ID, with its roles, person or company details, addresses, emails and phone numbers.

• Action
  Get a credit note

  Returns one Lexware Office credit note by its ID, with its recipient, line items, totals and status.

• Action
  Get a delivery note

  Returns one Lexware Office delivery note by its ID, with its recipient, delivered lines and delivery date.

• Action
  Get a dunning

  Returns a single dunning (payment reminder) by its ID, including its addressee, line items, totals and PDF file reference.

• Action
  Get an article

  Returns a single article (product or service) by its ID, including its name, article number, unit and pricing.

• Action
  Get an invoice

  Returns a single invoice by its ID, including its addressee, line items, totals, payment terms and PDF file reference.

• Action
  Get an order confirmation

  Returns a single order confirmation by its ID, including its addressee, line items, totals and PDF file reference.

• Action
  Get a quotation

  Returns a single quotation by its ID, including its addressee, line items, totals, expiry date and PDF file reference.

• Action
  Get a voucher

  Returns a single bookkeeping voucher by its ID, including its type, contact, amounts, line items and attached files.

• Action
  Get payment information

  Returns the payment status of a voucher, such as an invoice: how much is still open, when it was paid, and the individual payments booked against it.

• Action
  Pursue to a credit note

  Creates a credit note that follows on from an existing invoice, linking the two in Lexware Office. Copies the invoice's recipient, lines and tax settings unless you supply your own lines.

• Action
  Pursue to a delivery note

  Creates a delivery note that follows on from an existing order confirmation, linking the two in Lexware Office. Copies the recipient, lines and tax settings unless you supply your own lines.

• Action
  Pursue to a dunning

  Creates a dunning (payment reminder) that follows on from an unpaid invoice, linking the two in Lexware Office. Copies the recipient, lines and tax settings unless you supply your own lines.

• Action
  Pursue to an invoice

  Creates an invoice that follows on from an existing order confirmation, linking the two in Lexware Office. Copies the recipient, lines and tax settings unless you supply your own lines.

• Action
  Pursue to an order confirmation

  Creates an order confirmation that follows on from an existing quotation, linking the two in Lexware Office. Copies the recipient, lines and tax settings unless you supply your own lines.

• Action
  Update a contact

  Updates an existing contact in Lexware Office. Reads the contact first and changes only the details you fill in, leaving everything else as it was.

• Action
  Update an article

  Updates an existing article in Lexware Office. Reads the article first and changes only the details you fill in, leaving everything else as it was.

• Action
  Update a voucher

  Updates an existing bookkeeping voucher in Lexware Office. Reads the voucher first and changes only the details you fill in, leaving everything else as it was.

• Action
  Upload Document for Bookkeeping Purposes

  Uploads a receipt or other document to Lexware Office for bookkeeping and returns its file ID, which you can attach to a voucher.

• Trigger
  New Dashboard

  Triggers when a new dashboard is created in Looker.

• Trigger
  New Look

  Triggers when a new Look is saved in Looker.

• Trigger
  New User

  Triggers when a new user is added to Looker.

• Action
  Add Group

  Creates a new user group in Looker (admin only).

• Action
  Add Role(s) to User

  Sets the roles assigned directly to a Looker user, replacing their current direct roles.

• Action
  Add Scheduled Plan

  Creates a scheduled plan that delivers a Look, dashboard, LookML dashboard or query to one or more destinations on a recurring schedule.

• Action
  Add User to Group

  Adds a user to a Looker group.

• Action
  Create Credentials - Email

  Adds an email login to a Looker user.

• Action
  Create Render Task

  Starts rendering a Look to an image or PDF; use Get Render Task Results with the returned ID once it finishes.

• Action
  Create User

  Creates a new user in Looker with the given name and details.

• Action
  Delete User

  Deletes a user from Looker.

• Action
  Find User

  Finds Looker users matching an email or name.

• Action
  Get Dashboard

  Returns the full details of a Looker dashboard, including its tiles, filters and layouts.

• Action
  Get Look

  Returns a saved Look's details, including its title, folder, owner, URLs and the query behind it.

• Action
  Get Render Task Results

  Returns the image or PDF file produced by a completed render task.

• Action
  Get User

  Returns a Looker user's details by user ID, including name, email, roles, groups and credentials.

• Action
  List Dashboards

  Returns all active dashboards in your Looker instance with summary details such as id, title and folder.

• Action
  List Groups

  Returns the user groups in your Looker instance, optionally filtered by ID or content access.

• Action
  List Looks

  Returns all active Looks the connected user has access to, with their titles, folders and owners.

• Action
  Run Look

  Runs a saved Look and returns its result rows.

• Action
  Send Password Reset or Account Setup Email

  Sends a Looker user a password reset email, or an account setup email if they have not set up their account yet.

• Action
  Update User

  Updates a Looker user's name, home folder, locale or disabled status, and returns the updated user.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.