Description

Sellsy is an online customer relationship management (CRM) and sales management platform.

Connector Details

NameValue
PlatformSellsy
Auth TypeAPI Keys
DirectionRead

Supported Data

See the table below for the list of data you can read with the Sellsy connector.

Table NameFields
invoice_items
id, corpname, ownerFullName, status, filename, fileid, nbpages, ident, thirdident, thirdname, thirdid, thirdvatnum, contactId, contactName, displayedDate, currencysymbol, subject, docspeakerText, docspeakerStaffId, docspeakerStaffFullName, corpaddressid, thirdaddressid, shipaddressid, rowsAmount, discountPercent, discountAmount, rowsAmountDiscounted, offerAmount, rowsAmountAllInc, packagingsAmount, shippingsAmount, totalAmountTaxesFree, taxesAmountSum, taxesAmountDetails, totalAmount, useEcotaxe, totalEcoTaxFree, totalEcoTaxInc, ecoTaxId, taxBasis, payDateText, payDateCustom, hasDeadlines, payMediumsText, payCheckOrderText, payBankAccountText, shippingNbParcels, shippingWeight, shippingWeightUnit, shippingVolume, shippingTrackingNumber, shippingTrackingUrl, shippingDate, saveThirdPrefs, displayShipAddress, analyticsCode, recorded, recordable, rateCategory, isTaxesInc, hasDoubleVat, stockImpact, isFromPresta, eCommerceShopId, signcoords, esignID, promotionid, useServiceDates, serviceDateStart, serviceDateStop, locked, reconciledStatus, fiscalYearId, enable_draft_number, corpid, ownerid, linkedtype, linkedid, created, prefsid, parentid, docmapid, hasVat, period_start, thirdRelationType, auxCode, thirdemail, thirdtel, thirdmobile, doctypeid, step, isDeposit, posId, dueAmount, isSepaExported, lastSepaExportDate, orderIdent, docid, currencyid, currencyposition, numberformat, numberdecimals, numberthousands, numberprecision, notes, bankaccountid, publicLinkAvailable, marge, percentmarge, marge_tauxMarque, marge_tauxMarge, payDateCustomUnix, formatted_dueAmount, formatted_tauxMarque, formatted_tauxMarge, formatted_marge, note, step_color, step_hex, step_label, step_css, step_banner, step_id, displayed_payMediumsText, formatted_totalAmount, formatted_totalAmountTaxesFree, formatted_created, formatted_displayedDate, formatted_payDateCustom, formatted_serviceDateStart, formatted_serviceDateStop, formatted_lastSepaExportDate, formatted_lastpayment, noedit, rateCategoryFormated, publicLinkShort, fiscalYear, tags, smartTags, thirdStatus, formatted_rowsAmount, formatted_discountPercent, formatted_discountAmount, formatted_rowsAmountDiscounted, formatted_offerAmount, formatted_rowsAmountAllInc, formatted_packagingsAmount, formatted_shippingsAmount, formatted_taxesAmountSum, formatted_shippingWeight, formatted_shippingVolume, formatted_globalDiscount, formatted_globalOffer, formatted_deposit, formatted_totalEcoTaxDisplay, tel, fax, email, map
invoices
id, corpname, ownerFullName, status, filename, fileid, nbpages, ident, thirdident, thirdname, thirdid, thirdvatnum, contactId, contactName, displayedDate, currencysymbol, subject, docspeakerText, docspeakerStaffId, docspeakerStaffFullName, corpaddressid, thirdaddressid, shipaddressid, rowsAmount, discountPercent, discountAmount, rowsAmountDiscounted, offerAmount, rowsAmountAllInc, packagingsAmount, shippingsAmount, totalAmountTaxesFree, taxesAmountSum, taxesAmountDetails, totalAmount, useEcotaxe, totalEcoTaxFree, totalEcoTaxInc, ecoTaxId, taxBasis, payDateText, payDateCustom, hasDeadlines, payMediumsText, payCheckOrderText, payBankAccountText, shippingNbParcels, shippingWeight, shippingWeightUnit, shippingVolume, shippingTrackingNumber, shippingTrackingUrl, shippingDate, saveThirdPrefs, displayShipAddress, analyticsCode, recorded, recordable, rateCategory, isTaxesInc, hasDoubleVat, stockImpact, isFromPresta, eCommerceShopId, signcoords, esignID, promotionid, useServiceDates, serviceDateStart, serviceDateStop, locked, reconciledStatus, fiscalYearId, enable_draft_number, corpid, ownerid, linkedtype, linkedid, created, prefsid, parentid, docmapid, hasVat, period_start, thirdRelationType, auxCode, thirdemail, thirdtel, thirdmobile, doctypeid, step, isDeposit, posId, dueAmount, isSepaExported, lastSepaExportDate, orderIdent, docid, currencyid, currencyposition, numberformat, numberdecimals, numberthousands, numberprecision, notes, bankaccountid, publicLinkAvailable, marge, percentmarge, marge_tauxMarque, marge_tauxMarge, payDateCustomUnix, formatted_dueAmount, formatted_tauxMarque, formatted_tauxMarge, formatted_marge, note, step_color, step_hex, step_label, step_css, step_banner, step_id, displayed_payMediumsText, formatted_totalAmount, formatted_totalAmountTaxesFree, formatted_created, formatted_displayedDate, formatted_payDateCustom, formatted_serviceDateStart, formatted_serviceDateStop, formatted_lastSepaExportDate, formatted_lastpayment, noedit, rateCategoryFormated, publicLinkShort, fiscalYear, tags, smartTags, thirdStatus
items
id, type, corpid, ownerid, status, actif, isEnabled, rank, name, tradename, tradenametonote, notes, unitAmount, unitAmountIsTaxesFree, useEcoTax, ecoTaxType, ecoTax, unitid, unit, qt, taxid, taxrate, purchaseAmount, costPerHour, createdAt, updatedAt, useDeclination, stickyNote, categoryid, inPos, timetrackingEnabled, categoryName, promoid, translationsLangs, itemid, decl_id, declid, analyticsCode, accountingPurchaseCode, accountingCode, refAmount, accountingCodeService, hasPriceException, typeLabel, stockItemQt, nameSample, notesSample, notesFormated, notesHTMLSample, isTaxesFree, isTaxesFreeBool, purchaseAmountTaxesInc, unitAmountTaxesInc, formatted_purchaseAmount, formatted_purchaseAmountTaxesInc, formatted_unitAmount, formatted_unitAmountTaxesInc, formatted_qt, formatted_taxrate, slug, prices, formated_rc_183532, formated_rc_183533, promotion, defaultImage, galery, tags, accountingCodeVal, accountingPurchaseCodeVal
purchase_order_items
id, corpid, ownerid, corpname, purdocmapid, prefsid, linkedtype, linkedid, parentid, thirdid, thirdname, thirdvatnum, hasVat, status, fileid, filename, nbpages, ident, thirdident, created, displayedDate, currencysymbol, docspeakerText, docspeakerStaffId, docspeakerStaffFullName, ownerFullName, subject, corpaddressid, thirdaddressid, shipaddresstype, shipthirdid, shipaddressid, rowsAmount, discountPercent, discountAmount, rowsAmountDiscounted, offerAmount, rowsAmountAllInc, packagingsAmount, shippingsAmount, totalAmountTaxesFree, taxesAmountSum, taxesAmountDetails, totalAmount, useEcotaxe, totalEcoTaxFree, totalEcoTaxInc, ecoTaxId, payDateText, payDateCustom, payMediumsText, payCheckOrderText, payBankAccountText, shippingNbParcels, shippingWeight, shippingWeightUnit, shippingVolume, shippingTrackingNumber, shippingTrackingUrl, shippingDate, displayShipAddress, saveThirdPrefs, contactId, contactName, analyticsCode, recordable, recorded, rateCategory, isTaxesInc, stockImpact, isFromPresta, oldid, reconciledStatus, fiscalYearId, overrideTotals, thirdRelationType, thirdStatus, doctypeid, step, ref, deliverystep, expireDate, showSignAndStamp, purdocid, currencyid, currencyposition, numberformat, numberdecimals, numberthousands, numberprecision, notes, nbLinked, payAmount, lastpayment, period_start, step_color, step_hex, step_label, step_css, step_banner, step_id, note, deliverystep_label, deliverystep_css, deliverystep_banner, deliverystep_color, deliverystep_id, itemname, displayed_payMediumsText, formatted_totalAmount, formatted_totalAmountTaxesFree, formatted_displayedDate, formatted_created, formatted_payDateCustom, formatted_lastpayment, formatted_expireDate, noedit, hasLoadableFileId, fiscalYear, externalident, map
purchase_orders
id, corpid, ownerid, corpname, purdocmapid, prefsid, linkedtype, linkedid, parentid, thirdid, thirdname, thirdvatnum, hasVat, status, fileid, filename, nbpages, ident, thirdident, created, displayedDate, currencysymbol, docspeakerText, docspeakerStaffId, docspeakerStaffFullName, ownerFullName, subject, corpaddressid, thirdaddressid, shipaddresstype, shipthirdid, shipaddressid, rowsAmount, discountPercent, discountAmount, rowsAmountDiscounted, offerAmount, rowsAmountAllInc, packagingsAmount, shippingsAmount, totalAmountTaxesFree, taxesAmountSum, taxesAmountDetails, totalAmount, useEcotaxe, totalEcoTaxFree, totalEcoTaxInc, ecoTaxId, payDateText, payDateCustom, payMediumsText, payCheckOrderText, payBankAccountText, shippingNbParcels, shippingWeight, shippingWeightUnit, shippingVolume, shippingTrackingNumber, shippingTrackingUrl, shippingDate, displayShipAddress, saveThirdPrefs, contactId, contactName, analyticsCode, recordable, recorded, rateCategory, isTaxesInc, stockImpact, isFromPresta, oldid, reconciledStatus, fiscalYearId, overrideTotals, thirdRelationType, thirdStatus, doctypeid, step, ref, deliverystep, expireDate, showSignAndStamp, purdocid, currencyid, currencyposition, numberformat, numberdecimals, numberthousands, numberprecision, notes, nbLinked, payAmount, lastpayment, period_start, step_color, step_hex, step_label, step_css, step_banner, step_id, note, deliverystep_label, deliverystep_css, deliverystep_banner, deliverystep_color, deliverystep_id, itemname, displayed_payMediumsText, formatted_totalAmount, formatted_totalAmountTaxesFree, formatted_displayedDate, formatted_created, formatted_payDateCustom, formatted_lastpayment, formatted_expireDate, noedit, hasLoadableFileId, fiscalYear, externalident