...
property
...
mapping
...
values
...
Introducation
The following tables shows you the data returned from the Swiss Company Registry and how you can map it in the ReadExternalDataById activity.
Property | Mapping | Values | Default-value if source is NULL |
|---|
displayname | ExternalData.Result.DisplayName
| | - |
UID | ExternalData.Result.Identifier
| | - |
legalform | ExternalData.Result.Properties["LegalForm"]
| 4-digit code. Meaning of the codes according to the documentation eCH-0097 https://www.ech.ch/de/dokument/118884fc-0563-4ad0-924d-f6c3c02533a9 Example for mapping in the workflow: | Code Block |
|---|
switch (ExternalData.Result.Properties["LegalForm"]){
case "0101":
LegalForm = "Einzelunternehmen"
break;
case "0103":
LegalForm = "Kollektivgesellschaft";
break;
case "9999":
LegalForm = "n/a"
break;
default:
LegalForm = "Andere"
} |
| 9999
|
VAT-number | ExternalData.Result.Properties["VatUid"]
| | n/a
|
company name | ExternalData.Result.Properties["OrganisationName"]
| | n/a
|
company addidional name | ExternalData.Result.Properties["OrganisationAdditionalName"]
| | n/a
|
street | ExternalData.Result.Properties["Street"]
| | n/a
|
street number | ExternalData.Result.Properties["HouseNumber"]
| | n/a
|
zipcode | ExternalData.Result.Properties["SwissZipCode"]
| | n/a
|
postbox | ExternalData.Result.Properties["PostOfficeBoxNumber"]
| | n/a
|
city | ExternalData.Result.Properties["City"]
| | n/a
|
country | ExternalData.Result.Properties["Country"]
| Two-character, alphanumeric ISO country code according to [ISO 3166-1] of the country in where the addressed location is located. (eCH-0010) | n/a
|
canton abbreviation | ExternalData.Result.Properties["CantonAbbreviation"]
| | n/a
|
EGID | ExternalData.Result.Properties["EgId"]
| | n/a
|
municipality ID | ExternalData.Result.Properties["MunicipalityId"]
| | n/a
|
deliverable | ExternalData.Result.Properties["DeliverableYesNo"]
| TRUE / FALSE
| FALSE
|
UID-state | ExternalData.Result.Properties["CommercialRegisterEntryStatus"]
| "active"
"deleted"
"provisional"
| n/a
|