Excel Add-In for BCart

Build 22.0.8503

Customers

Returns data from Customers table.

Select

The 本製品 will use the BCart API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

  • Most of the columns support the following operators: <, >, <=, >=, =, !=, IN, NOT_IN.
  • Custom field columns support the following operator: =.
  • Password column does not support server side operators.
For example, the following query is processed server side:
    SELECT * FROM Customers WHERE CompName = 'Sample Company'
    SELECT * FROM Customers WHERE ParentId IN (1,10)
    SELECT * FROM Customers WHERE UpdatedAt <= '2019-09-26 09:20:45'

Insert

To add a Customers, specify TantoLastName, Zip, Pref, Address1, Address2, Password and the non-read-only columns.

    INSERT INTO Customers(TantoLastName,Zip,Pref,Address1,Address2,Password)VALUES('Tanto','123-4567','Miyagi','Sendai','CData','PASSWPRD')

Bulk Insert


    INSERT INTO Customers#TEMP(TantoLastName,Zip,Pref,Address1,Address2,Password)VALUES('Tanto 1','123-4567','Miyagi','Sendai','CData','PASSWPRD')
    INSERT INTO Customers#TEMP(TantoLastName,Zip,Pref,Address1,Address2,Password)VALUES('Tanto 2','123-4567','Miyagi','Sendai','CData','PASSWPRD')
    INSERT INTO Customers (Name,CategoryId) SELECT Name,CategoryId FROM Customers#TEMP

Update

BCart allows updates for TantoLastName, Zip and the non-read-only columns.

    UPDATE Customers SET TantoLastName = 'Sample TantoLastName' WHERE Id = 2

Bulk Update


    INSERT INTO Customers#TEMP (Id,TantoLastName,Address1) VALUES(1,'Sample TantoLastName 1','Sendai')
    INSERT INTO Customers#TEMP (Id,TantoLastName,Address1) VALUES(2,'Sample TantoLastName 2','Sendai')
    UPDATE Customers (Id,TantoLastName,Address1) SELECT Id,TantoLastName,Address1 FROM Customers#TEMP

Delete

Delete is not supported for this table.

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

ExtId String False

AgentId String False

AgentRate String False

ParentId Integer False

DestinationCode String False

CompName String False

CompNameKana String False

CeoLastName String False

CeoFirstName String False

CeoLastNameKana String False

CeoFirstNameKana String False

Department String False

TantoLastName String False

TantoFirstName String False

TantoLastNameKana String False

TantoFirstNameKana String False

Zip String False

Pref String False

Address1 String False

Address2 String False

Address3 String False

Email String False

EmailCc String False

Tel String False

MobilePhone String False

Fax String False

Url String False

Foundation String False

Sales Integer False

Job String False

Memo String False

Payment String False

SpecialShippingCost String False

Paid String True

SpecialView Integer False

MmFlag Integer False

Point Integer False

PriceGroupId Integer False

ViewGroupId Integer False

SalesmanId String False

AfId String False

CutoffDate String False

PaymentMonth String False

PaymentDate String False

DefaultOtherShippingId Integer False

DefaultPayment String False

HiddenPrice Integer False

Status String False

Password String False

CreatedAt Datetime False

UpdatedAt Datetime False

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8503