⚙️ Introduction

This job allows the creation and management of Accounts and their shipping/billing addresses via CSV import or API Connector.

You can:

Create new Accounts with their addresses
Update existing Accounts and their addresses
Link and unlink addresses from Accounts
Deactivate an Account
Delete an Account

📂 Import model

CSV Structure

The CSV file must contain one row per Account. To import multiple addresses for the same Account, add one row per address.

📄
Template
You can use the following spreadsheet as a template to structure your import:
Accounts - Template

API Connector

The API Connector sends data as a JSON payload. The JSON must always be a list of objects, regardless of the operation (create, update, deactivate, delete).

Addresses can be structured in two ways depending on how they are sent by the source system:

Option A — Addresses as a nested list

[
  {
    "accountName": "string",
    "accountExternalId": "string",
    "accountManagerName": "string",
    "accountWebsite": "string",
    "companyRegistrationName": "string",
    "businessRegistrationNumber": "string",
    "customerTagExternalId": "string",
    "accountVatNumber": "string",
    "deleted": false,
    "inactive": false,
    "address": [
      {
        "addressExternalId": "string",
        "addressFullName": "string",
        "addressCountry": "string",
        "addressCity": "string",
        "addressZipCode": "string",
        "addressStreetName": "string",
        "addressLabel": "string",
        "addressAdditionalStreetName": "string",
        "addressPhoneNumber": "string",
        "unlinkAddress": false,
        "shippingAddress": true,
        "billingAddress": true
      }
    ]
  }
]

Option B — Flat object structure

[
  {
    "accountName": "string",
    "accountExternalId": "string",
    "accountManagerName": "string",
    "accountWebsite": "string",
    "companyRegistrationName": "string",
    "businessRegistrationNumber": "string",
    "customerTagExternalId": "string",
    "accountVatNumber": "string",
    "deleted": false,
    "inactive": false,
    "addressExternalId": "string",
    "addressFullName": "string",
    "addressCountry": "string",
    "addressCity": "string",
    "addressZipCode": "string",
    "addressStreetName": "string",
    "addressLabel": "string",
    "addressAdditionalStreetName": "string",
    "addressPhoneNumber": "string",
    "unlinkAddress": false,
    "shippingAddress": true,
    "billingAddress": true
  }
]

💡
Note
When using the nested address structure, map the parent address array first before mapping the fields within each address object.

📋 Fields

Field	Definition	Required for creation	Required for update	Editable	Default Value
`Account Name`	Account name	✅		✅
`Account External Id`	Unique external identifier of the Account	✅	✅
`Account Manager Name`	Name of the account manager			✅
`Account Website`	Website URL of the Account			✅
`Company Registration Name`	Legal registered company name	✅		✅
`Business Registration Number`	Business registration number	✅		✅
`Customer Tag External Id`	External identifier of the customer tag			✅
`Account VAT Number`	VAT number of the Account			✅
`Deleted`	Set to `TRUE` to delete the Account			✅	`FALSE`
`Inactive`	Set to `TRUE` to deactivate the Account			✅	`FALSE`
`Address External Id`	Unique external identifier of the address	✅	☑️ (Required when updating an address)
`Address Full Name`	Full name associated with the address	✅		✅
`Address Country`	Country of the address	✅		✅
`Address City`	City of the address	✅		✅
`Address Zip Code`	Postal code of the address	✅		✅
`Address Street Name`	Street name of the address	✅		✅
`Address Label`	Label for identifying the address			✅
`Address Additional Street Name`	Additional address information			✅
`Address Phone Number`	Phone number associated with the address			✅
`Unlink Address From Account`	Set to `TRUE` to unlink an address from the Account			✅	`FALSE`
`Shipping Address`	Set to `TRUE` to define the address as a shipping address			✅	`TRUE`
`Billing Address`	Set to `TRUE` to define the address as a billing address			✅	`TRUE`

☑️
Conditionally required

⚠️
Required Custom Fields
Any custom fields configured as required in DJUST must also be included.

🧠 Key Business Rules

An Account can have one or more addresses.
By default, an address is defined as both a shipping and a billing address.
An address can be associated with multiple Accounts. In this case, all mandatory address fields must be provided — not only the Address External Id.
It is not possible to update an existing address already associated with another Account while simultaneously linking it to a new Account.
Account External Id and Address External Id cannot be updated once set.
Setting Inactive to TRUE deactivates the Account without deleting it. The Account will no longer be visible or usable on the platform.
Setting Deleted to TRUE permanently removes the Account. This action is irreversible.
Empty fields in standard columns do not delete recorded values.
Empty fields in Custom Fields delete the recorded values.

📌
Best Practices
✔️ Use the correct payload structure (nested vs flat) based on how addresses are sent by your source system.
✔️ Map the address parent array first when using the nested structure.
✔️ Map required Custom Fields before running the import.
✔️ Follow data formatting guidelines for optimal import results.