TidelyUploadInvoices - Tidely

← Tidely Add-On Übersicht

Import of invoices into your Tidely account.

Inputs

Das sind die Optionen, mit denen man den Step konfigurieren kann.

Name	Datentyp	Beschreibung	Pflichtfeld	Werte
account	ACCOUNT	API-credentials for the Tidely API.	Ja
invoices	SPREADSHEET	Spreadheet with invoice data to upload into your Tidely account.	Nein
mappingdefinition	STRING	The mapping definition JSON String	Nein
	Folgende Felder sind zu konfigurieren: Feld Datentyp Beschreibung Pflichtfeld Standardwert invoiceId SINGLE Unique identifier of the invoice, if not supplied we will generate one for you Nein createdDate SINGLE Created date of the invoice, if not supplied current date will be used pattern: dd.MM.yy, M/dd/yy, yyyy-MM-dd Nein updatedDate SINGLE Updated date of the invoice, if not supplied current date will be used pattern: dd.MM.yy, M/dd/yy, yyyy-MM-dd Nein invoiceDate SINGLE Invoice date, if not supplied current date will be used pattern: dd.MM.yy, M/dd/yy, yyyy-MM-dd Nein dueDate SINGLE Deadline of the invoice, if not supplied current date will be used pattern: dd.MM.yy, M/dd/yy, yyyy-MM-dd Nein invoiceNumber SINGLE Ja contactName SINGLE Recipient name of the invoice (e.g. Company name) Ja invoiceType SINGLE Ja totalGrossAmount SINGLE Total gross amount Ja invoiceStatus SINGLE Status of the invoice, if not supplied will be calculated based on the amounts. If the intention is to delete an already existing invoice status should be DELETED, If openAmount is 0 status will be PAID, if openAmount equals totalGrossAmount status will be OPEN, if openAmount is greater then 0 and lower then totalGrossAmount status will be PARTIALLY_PAID Nein currency SINGLE Currency of the amount, if not supplied euro will be used Nein totalNetAmount SINGLE Net amount of the invoice, if not supplied gross amount will be used Nein totalTaxAmount SINGLE Tax amount of the invoice, if not supplied 0 will be used Nein openAmount SINGLE Open amount of the invoice, if not supplied gross amount will be used Nein description SINGLE Description of the invoice Nein
limit	STRING	Limits the number of rows used from the input SPREADSHEET. Use low values for testing.	Nein

Outputs

Das sind die Ergebnisse des Steps, die von nachfolgenden Steps, nach der Ausführung verwendet werden können.

Name	Datentyp	Beschreibung	Werte
result	SPREADSHEET	Successfully created or updated invoices.
errors	SPREADSHEET	Errors which happened.