Connectors
Fishbowl Inventory
Connectors
Fishbowl Inventory
Description
Fishbowl is a provider of one-to-one guest-marketing products and services for the restaurant industry.
Connector Details
| Name | Value |
|---|---|
| Platform | Fishbowl Inventory |
| Auth Type | API Keys |
| Direction | Bidirectional |
Supported Data
See the table below for the list of data you can read with the Fishbowl Inventory connector.
| Table Name | Fields |
|---|---|
| accountgroup | name, id |
| accountgrouprelation | accountId, groupId, id |
| address | zip, defaultFlag, address, city, residentialFlag, stateId, countryId, accountId, name, addressName, typeID, id, locationGroupId |
| addresstype | name, id |
| contact | accountId, defaultFlag, contactName, datus, typeId, id, addressId |
| countryconst | name, id, abbreviation |
| customer | accountingHash, issuableStatusId, note, customFields, accountingId, carrierServiceId, number, defaultPaymentTermsId, dateCreated, dateLastModified, lastChangedUser, creditLimit, id, sysUSerId, currencyId, taxRateId, activeFlag, qbClassId, taxExempt, defaultSalesmanId, toBePrinted, parentId, url, defaultShipTermsId, accountID, defaultCarrierId, defaultPriorityId, statusId, toBeEmailed, name, currencyRate, jobDepth |
| customerstatus | name, id |
| images | recordId, id, type, imageFull, imageThumbnail, tableName |
| inventory | id, partNumber, quantity, partDescription, uom |
| locationgroup | dateLastModified, qbClassId, name, id, activeFlag |
| part | id, defaultProductId, dateLastModified, stdCost, num, description |
| paymentterms | id, typeId, name, discount |
| pricing_rule | spcGetYFree, rndPMAmount, customerInclTypeId, rndApplies, spcBuyX, description, dateEnd, paBaseAmountTypeId, isActive, rndToAmount, dateApplies, dateBegin, qtyMin, dateCreated, dateLastModified, paPercent, id, productInclId, qtyMax, rndTypeId, paApplies, userId, isAutoApply, paTypeId, spcApplies, paAmount, productInclTypeId, name, isTier2, qtyApplies, rndIsMinus, customerInclId |
| priority | name, id |
| product | accountingHash, sizeUomId, partId, customFields, accountingId, num, description, kitFlag, sellableInOtherUoms, dateCreated, dateLastModified, usePriceFlag, len, price, details, id, incomeAccountId, sku, defaultCartonTypeId, defaultSoItemType, activeFlag, height, cartonCount, qbClassId, taxableFlag, kitGroupedFlag, upc, weight, uomId, url, showSoComboFlag, taxId, displayTypeId, width, weightUomId, alertNote |
| sales_orders | shipToStateId, dateFirstShip, num, dateRevision, revisionNum, subTotal, billToCity, priorityId, mcTotalTax, totalTax, shipToCity, billToZip, dateCalStart, dateLastModified, registerId, id, currencyId, customerPO, taxRateId, locationGroupId, shipTermsId, dateCalEnd, salesmanId, salesmanInitials, dateExpired, calCategoryId, fobPointId, billToCountryId, shipToCountryId, taxRate, statusId, phone, estimatedTax, toBeEmailed, salesman, typeId, note, shipToAddress, totalPrice, customFields, carrierServiceId, totalIncludesTax, vendorPO, shipToResidential, billToAddress, paymentTermsId, shipToZip, dateCreated, customerContact, datecompleted, customerId, taxRateName, email, createdByUserId, dateIssued, cost, qbClassId, toBePrinted, billToName, url, shipToName, currencyRate, carrierId, billToStateId, username |
| soitem | note, qtyFulfilled, totalPrice, customFields, adjustPercentage, description, dateScheduledFulfillment, dateLastModified, id, mcTotalPrice, showItemFlag, qtyPicked, unitPrice, soId, qbClassId, productId, exchangeSOLineItem, taxableFlag, adjustAmount, dateLastFulfillment, uomId, productNum, customerPartNum, markupCost, taxRate, revLevel, statusId, qtyOrdered, taxId, qtyToFulfill, typeId, soLineItem, totalCost |
| stateconst | countryConstID, code, name, id |