Power BI Connector for Sage Business Cloud Accounting

Build 22.0.8342

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

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

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8342