Mapping SwissRegistry

Introduction

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

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: `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`