Alpaca and Lexware Office Integration

Demonstration of how apps are integrated in WEXTL workflow builder[4]

Connect Alpaca and Lexware Office to automate finance workflows. Trigger events from one app, run actions in the other and use AI to make smart decisions. Integrate apps in 3 simple steps - no code required.

  • 3-day trial
  • Cancel anytime
  • Up to 10 minutes quick set up
  • GDPR
  • Data Encryption
  • 2FA
  • Local Data Region

Learn about Alpaca and Lexware Office

Detailed info you need to know about Alpaca and Lexware Office integrations in WEXTL. Explore which modules apps support and how you connect them.

  • Alpaca

    • Finance
    • 3 triggers
    • 72 searches
    • 21 actions

    Trading and market data API for stocks, options and crypto.[5]

  • Lexware Office

    • Finance
    • 2 triggers
    • 29 searches
    • 16 actions

    Cloud bookkeeping and invoicing software for small businesses in Germany.[6]

How to connect Alpaca to Lexware Office

Set up your Alpaca and Lexware Office integration in 3 simple steps[2]. No coding required. Up to 10 minutes setup.

How does the integration between Alpaca and Lexware Office work in WEXTL?

WEXTL exposes actions and triggers for Alpaca and Lexware Office that help you connect apps and automate repetitive tasks[1]. A trigger is an event that happens, and an action is a step that performs when the event has occurred.

Alpaca triggersLexware Office actions

Alpaca modules

  • Add an Asset to a Watchlist Puts one more Symbol on a watchlist. The updated watchlist is returned with its Name and Assets.
  • Cancel All Orders Cancels every open order in the account once Confirm is turned on. Each canceled order is its own result with its ID and Status.
  • Cancel an Order Cancels one open order and returns its ID.
  • Close a Position Exits an open position in full, or by a Quantity or a Percentage of it. A partial close places a market order, labeled with your Client Order ID.
  • Close All Positions Closes every open position. Turn on Cancel Open Orders First to clear pending orders beforehand, and Confirm to go ahead.
  • Create a Locate Asks Alpaca to locate a Quantity of shares of a Symbol for shorting. Turn on All or None to reject a partial fill and use Limit Price for the highest fee you accept.
  • Create a Multi-Leg Options Order Places one options order across several Legs, each made of a Contract Symbol, Ratio Quantity and Side. The whole order takes a Quantity, Order Type and Time in Force.
  • Create a Watchlist Saves a new watchlist called Name, optionally filled with Symbols.
  • Create a Whitelisted Address Approves a crypto wallet Address for withdrawals of an Asset on a Chain, with optional beneficiary details for the travel rule.
  • Create an Order Submits an order for a Symbol as a market, limit, stop, stop limit or trailing stop. Use Quantity or Notional for the size and Order Class for a bracket, OCO or OTO.
  • Delete a Watchlist Deletes a watchlist and returns its ID.
  • Delete a Whitelisted Address Deletes an approved withdrawal address from the account.
  • Do Not Exercise an Option Position Tells Alpaca to let an option position expire without exercising it, returning its Symbol.
  • Exercise an Option Position Exercises an option position you hold and returns its Symbol with a Success flag.
  • Get a Corporate Action Announcement Fetches one announcement by ID, with its Ca Type, Ca Sub Type, Cash amount and Declaration Date.
  • Get a Crypto Transfer Fetches one wallet transfer, including its Amount, Asset, Chain and Direction.
  • Get a Crypto Transfer Estimate Quotes the Fee and Network Fee of moving an Amount of an Asset between a From Address and a To Address.
  • Get a Locate Reads one locate request by Locate ID and shows its Status, Located Quantity and Total Fee.
  • Get a Logo Downloads the company logo for a Symbol as a File with its Content Type. Turn on Placeholder If Missing to get a stand-in image.
  • Get a Position Shows one open position with its Avg Entry Price and Asset Class.
  • Get a Stock Snapshot Takes a current picture of one Symbol with its Daily Bar, Latest Quote, Latest Trade and Prev Daily Bar.
  • Get a Tokenization Request Fetches one tokenization request by its ID, including what Fees were charged.
  • Get a Tokenization Request by Client Request ID Finds a tokenization request from the Client Request ID that was attached when minting, and shows its full record.
  • Get a Watchlist Opens one watchlist and shows its Name and Assets.
  • Get Account Configurations Reads the trading settings of the account, such as Fractional Trading, Max Margin Multiplier and No Shorting.
  • Get an Asset Looks up an asset by Symbol or Asset ID and returns its Class, Exchange, CUSIP and Borrow Status.
  • Get an Option Chain Snapshots the contracts on an Underlying Symbol, with Greeks, Implied Volatility and the Latest Quote. Narrow by Type, Strike Price From, Strike Price To or Expiration Date.
  • Get an Option Contract Retrieves one contract with its Expiration Date, Close Price and Deliverables.
  • Get an Order Fetches one order by Order ID with its Client Order ID, Created At and Asset Class. Turn on Nest Multi-Leg Orders to show the legs inside it.
  • Get an Order by Client Order ID Finds an order from the Client Order ID you attached when placing it, so a custom reference leads to the full order.
  • Get Latest Crypto Orderbooks Shows the current order book of crypto pairs in a chosen Location, listing Asks and Bids. Use Limit to set the depth.
  • Get Locate Quotes Quotes the Available Quantity and Price of shares you could locate for each of the Symbols.
  • Get Option Condition Codes Looks up what each trade condition code means for a Tick Type on options.
  • Get Option Exchange Codes Lists the exchange codes that appear in options data, so a code can be read as an exchange name.
  • Get Portfolio History Charts account value over time, one row per window with Timestamp, Equity, Profit Loss and Profit Loss Pct. Use Period for a lookback, or Start and End for exact dates, and Timeframe for the window size.
  • Get Stock Auctions Pulls the opening and closing auctions of one ticker from a Start date through to the End. Use Sort to put them in oldest or newest order.
  • Get Stock Bars Reads historical bars of one ticker at the chosen Timeframe, with High, Low, Close and Trade Count. Use Adjustment to account for splits and dividends.
  • Get Stock Condition Codes Explains the condition codes of trades or quotes for a Tick Type on one Tape.
  • Get Stock Exchange Codes Lists the exchange codes that appear in stock data, with the exchange each one stands for.
  • Get Stock Quotes Reads historical bid and ask quotes of one ticker, with Ask Exchange and Ask Price. Use Sort to order them and Start with End to bound the period.
  • Get Stock Trades Reads historical trades of one ticker with Trade ID, Price and Size, across a period from Start to End.
  • Get the Account Pulls the trading account and reports its Account Number, Buying Power and Accrued Fees, along with whether it is blocked.
  • Get the Latest Stock Bar Fetches the newest bar for one Symbol with its High, Low, Close and Trade Count. Switch Feed or Currency for another source or currency.
  • Get the Latest Stock Quote Shows the latest best bid and ask for one Symbol, with Ask Price, Ask Size and Bid Price.
  • Get the Latest Stock Trade Reads the most recent trade of one Symbol, with its Price, Size and Conditions.
  • Get the Market Calendar Lists trading days for a Market from Start to End, with Core Start, Core End and Lunch Start. Use Time Zone to read times in your own zone.
  • Get the Market Clock Shows whether markets are open now, or at a chosen Time, with Phase, Next Market Open and Next Market Close. Use Markets for several codes.
  • List Account Activities Lists account events such as fills and transfers. Filter with Activity Types, Category, Order Id or a Date range using After and Until, and set Direction.
  • List Assets Lists the assets that match Status, Asset Class, Exchange or Attributes.
  • List Corporate Action Announcements Lists announcements of the chosen Types from Since until Until. Add Symbol or CUSIP to follow one security and Date Type to choose which date is matched.

Lexware Office modules

  • Create a Bookkeeping Voucher Records a receipt as a bookkeeping voucher, with sales types for income and purchase types for expenses. Set Status to Unchecked to finish the voucher in Lexware later.
  • Create a Contact Adds a company or a person to Lexware as a customer, a vendor or both. Lexware assigns the customer and vendor numbers itself. Use Company Name when the contact is a company.
  • Create a Credit Note Writes a credit note from a Credit Note Date, Line Items and a Tax Type, left as a draft unless Status After Creation says otherwise. Use Refunds to link the invoice being refunded.
  • Create a Delivery Note Prepares a delivery note with a Shipping Type and Line Items. Delivery notes carry no totals. Use Follows From to base it on an earlier sales document.
  • Create a Dunning Drafts a payment reminder dated by Reminder Date, with Line Items and a Tax Type. Use Tax Sub Type for reminders to private customers in the EU.
  • Create a Quotation Creates a quotation dated by Quotation Date and expiring at Valid Until, with Line Items that may be marked as Optional Item. Leave Status After Creation empty for a draft.
  • Create an Article Saves an article under a Title, Type, Unit and Tax Rate. Use Leading Price to say whether the Net Price or the Gross Price is entered, and Lexware calculates the other.
  • Create an Invoice Creates an invoice from up to 300 Line Items. Leave Status After Creation empty to get a draft, because a finalized invoice can no longer be changed through the API.
  • Create an Order Confirmation Creates an order confirmation from an Order Confirmation Date, Line Items and a Shipping Type. Use Follows From to link the quotation behind it.
  • Delete an Article Deletes an article from Lexware. Deleting cannot be undone.
  • Download a Bookkeeping File Fetches a receipt or further bookkeeping file. A Format the file cannot be turned into gives an error.
  • Download a Credit Note File Fetches the file for a credit note once finalized. Leave Format empty for the default file, which is the PDF.
  • Download a Delivery Note File Delivers the document file of a delivery note. Drafts have no file yet. Output includes the File Name and Content Type.
  • Download a Down Payment Invoice File Pulls a down payment invoice as a file. Only e-invoices have an XML file, which Format can request.
  • Download a Dunning File Retrieves the file of a payment reminder, using the Dunning ID from Create a Dunning. Lexware has no list of payment reminders.
  • Download a Quotation File Obtains a finalized quotation as a PDF by default, since a draft has no file yet.
  • Download an Invoice File Downloads a finalized invoice. With the default Format you receive the XML for XRechnung invoices and the PDF for all others.
  • Download an Order Confirmation File Saves the order confirmation document as a file, in the default PDF unless Format asks for another value Lexware accepts.
  • Get a Bookkeeping Voucher Reads a bookkeeping voucher with its Voucher Status, Voucher Date, Total Gross Amount and Contact Name.
  • Get a Contact Opens a contact, including its Roles, Addresses and Email Addresses.
  • Get a Credit Note Looks up a credit note and shows the Voucher Status, Voucher Number and Total Price.
  • Get a Delivery Note Looks up a delivery note, showing its Voucher Number, Shipping Conditions and Line Items.
  • Get a Down Payment Invoice Returns a down payment invoice, including the Due Date and Electronic Document Profile.
  • Get a Dunning Fetches a payment reminder by its Dunning ID, with its Voucher Status and Line Items.
  • Get a Quotation Reads a quotation and reports its Expiration Date and Line Items.
  • Get a Recurring Invoice Template Retrieves a recurring invoice template, giving its Title, Payment Conditions and Line Items.
  • Get an Article Reads one article from Lexware, showing its Title, Type, Article Number and Price.
  • Get an Invoice Reads an invoice and reports the Voucher Status, Due Date, XRechnung details and Electronic Document Profile.
  • Get an Order Confirmation Pulls an order confirmation, including its Voucher Number, Line Items and Tax Amounts.
  • Get Payment Status Shows how an invoice, credit note or voucher stands on payment, with the Payment Status, Open Amount, Paid Date and Payment Items.
  • Get the Company Profile Returns who the connected Lexware account belongs to, with the Company Name, Subscription Status and Tax Type.
  • List Articles Returns articles, narrowed by Article Number, GTIN or Type. Lexware returns results 250 at a time.
  • List Contacts Searches contacts by part of a Name or Email, by Contact Number, or by role with Is Customer and Is Vendor.
  • List Countries Shows the countries Lexware knows, giving each Country Code and Tax Classification.
  • List Payment Conditions Retrieves the payment terms set up in Lexware, with the Payment Term Duration (Days) and which term is the Organization Default.
  • List Posting Categories Finds the posting categories, with their Type and whether Split Allowed applies.
  • List Print Layouts Lists the print layouts by Name and flags which one is the Default. Use Limit to cap the number returned.
  • List Recurring Invoice Templates Lists recurring invoice templates with their Recurring Template Settings. The default order is most recently updated first, which Sort By can change.
  • Make an API Call Makes an authorized free-form request to the Lexware Office REST API with your saved credential.
  • Search Vouchers Finds sales documents, receipts and other vouchers by Voucher Types and Voucher Statuses. Add Voucher Date From and Voucher Date To to limit them by date.
  • Update a Bookkeeping Voucher Edits a bookkeeping voucher. Use Status to move an unchecked voucher to Open, the only move Lexware allows, and keep Total Gross Amount equal to the sum of the items plus tax.
  • Update a Contact Changes a contact. Use Add Customer Role or Add Vendor Role to give it a role, since roles cannot be removed through the API.
  • Update an Article Edits an article. Change its Title, Unit or Tax Rate, or any other article value.
  • Upload a Bookkeeping File Uploads a PDF, JPG, PNG or XML receipt of up to 5 MB, which Lexware turns into a bookkeeping voucher in the background. Output includes the File ID and Voucher ID.
  • Upload a File to a Voucher Attaches a receipt file to an existing bookkeeping voucher. Each file can be attached only once.
  • Watch Events Starts the workflow the instant Lexware Office sends a webhook event. Output includes the Event Type, Resource ID and Event Date.
  • Watch Vouchers Polls Lexware on a schedule for vouchers that are created or updated. Use Voucher Types and Voucher Statuses to narrow what is watched, and Limit to cap the vouchers per run.

Explore alternative integrations

There are other apps[9] supported by WEXTL that can be paired with Alpaca and Lexware Office integrations. Pick any from the list below if the current combination isn't the one you need.

Automate Alpaca and Lexware Office on WEXTL®

Claim your 3-day trial to build Alpaca with Lexware Office integration and access every WEXTL® feature.

Cancel anytime.

Frequently asked questions

Common questions about connecting Alpaca and Lexware Office.

How do I connect Alpaca and Lexware Office?

Connect your Alpaca and Lexware Office accounts once, pick a trigger in one app and an action in the other, then map the fields so data flows automatically between them.[3]

What can I automate between Alpaca and Lexware Office?

Example: when the "Watch Account Activity" trigger in Alpaca fires, WEXTL can "Create a Bookkeeping Voucher" in Lexware Office. Alpaca has 3 triggers (including Watch Account Activity, Watch New Fills, and Watch New Orders). Lexware Office has 45 actions (including Create a Bookkeeping Voucher, Create a Contact, and Create a Credit Note). Add filters and transforms between steps when you need them.[1]

Can Alpaca trigger actions in Lexware Office, and Lexware Office in Alpaca?

Yes. The integration works in both directions. Use the triggers of each app to start a workflow and the actions of the other app to update it.[2]

Do I need to write code to integrate Alpaca and Lexware Office?

No. Alpaca-to-Lexware Office automations are built visually on the canvas. You can optionally add custom JavaScript with Functions when you need advanced logic.[4]

Does Alpaca integrate with Lexware Office in real time?

Yes. Trigger-based automations start the moment Alpaca (or Lexware Office) fires a new event. Webhook-backed apps run within seconds, and polling-only apps re-check on a schedule you control.[7]

How long does it take to set up a Alpaca + Lexware Office integration?

A first automation typically takes 5–10 minutes: connect the credential of each app once, drop a trigger + action onto the canvas, map the fields, and turn the workflow on.

Do I need a paid plan to connect Alpaca with Lexware Office?

You can build your Alpaca + Lexware Office automation on a 3-day trial with every feature unlocked. Cancel anytime.[8]

References

List of sources used to gather information about the Alpaca and Lexware Office integration.

  1. Alpaca and Lexware Office integration source code, module specs and credentials implementation.
  2. Our Alpaca and Lexware Office integration documentation, structured input and output parameters, scopes, and authentication methods.
  3. Official vendor API documentation for Alpaca and Lexware Office, used to verify field meanings, authentication flows, and anything our own specs don't fully capture.
  4. WEXTL® visual workflow builder, anonymized data from our technical support team.
  5. Alpaca integration information
  6. Lexware Office integration information
  7. WEXTL® Scheduling
  8. WEXTL® Pricing and Trial
  9. WEXTL® Apps Library

How we write our apps documentation

Explore how WEXTL® crafted Alpaca and Lexware Office integration page documentation. Used sources, the role of AI, and how the team validates the result.

Explore Alpaca and Lexware Office, or get started