Addresses

Query Addresses in Sage Business Cloud Accounting.

Table Specific Information

Query the available Addresses

Select

The driver uses the Sage Accounting API to process search criteria that refer to BankAccountId,ContactId,UpdatedOrCreatedSince,DeletedSince columns. The driver processes other filters client-side within the driver.

BankAccountId supports the '=' operator.
ContactId supports the '=' operator.
UpdatedOrCreatedSince supports the '=' operator.
DeletedSince supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM Addresses WHERE BankAccountId = '80b34e32b85a46c39a71c3627d577fa2'
SELECT * FROM Addresses WHERE ContactId = 'abc'
SELECT * FROM Addresses WHERE UpdatedOrCreatedSince = '2018-12-15'
SELECT * FROM Addresses WHERE DeletedSince = '2019-10-02T11:46:53Z'

Insert

Create a simple address.

INSERT INTO  [Addresses] (AddressTypeId, name, IsMainAddress, ContactId) VALUES ('DELIVERY', 'AddressName', 'false', '456')

Update

Updates are performed based on Id.

UPDATE Addresses SET AddressTypeId = 'DELIVERY' WHERE Id = 'c04b66f130d14478b7978452aeedb8ad'

Delete

You must specify the Id of the Addresses to delete it.

DELETE FROM Addresses WHERE id = 'c04b66f130d14478b7978452aeedb8ad'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The unique identifier for the item
CreatedAt	Datetime	True		The datetime when the item was created
AddressTypeId	String	False		The unique identifier for the item The allowed values are DELIVERY, ACCOUNTS, SALES, PURCHASING.
Region	String	False		The address state/province/region
PostalCode	String	False		The address postal code/zipcode
DeletedAt	Datetime	True		The datetime when the item was deleted
BankAccountId	String	False	BankAccounts.Id	The unique identifier for the item
IsMainAddress	Bool	False		Indicates whether this is a main address
CountryId	String	False	Countries.Id	The unique identifier for the item
DisplayedAs	String	False		The name of the resource
City	String	False		The address town/city
ContactId	String	False	Contacts.Id	The unique identifier for the item
LegacyId	Int	False		The legacy ID for the item
CountryGroupId	String	False	CountryGroups.Id	The unique identifier for the item
AddressLine2	String	False		The second line of the address
AddressLine1	String	False		The first line of the address
Name	String	False		The name of the address
UpdatedAt	Datetime	True		The datetime when the item was last updated
DeletedSince	Datetime	True