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 使用できる値は次のとおりです。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 |
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 |