Using bulkImport in backend code to import an Address field into a CMS Collection

Ask the community
, , ,
1

Question:
when importing an address field into a collection, what is the minimal formatting that can be used to successfully import the address? if my string is Phoenix, AZ, USA, how can i import that successfully in an address field? I don’t want to have to map full state names to state abbreviations, or full country names to country abbreviations.

Product:
Wix Studio Editor

What are you trying to achieve:
i want to be able to import an Address field when all i have to base it on is a string containing city, state, country

What have you already tried:
i’ve tried {"formatted": "${value}"}

Additional information:
seems like this would be something pretty common to do, i’m surprised i cannot find any wix documentation about import address fields. Tried using GROK, but it wants me to do something like the following, but i don’t have a mapping for all state names to their abbreviations, especially when you get beyond the U.S.

`{
  "formatted": "${value}",
  "city": "${city}",
  "country": "US",
  "subdivisions": [
    {
      "code": "US",
      "name": "United States",
      "type": "COUNTRY"
    },
    {
      "code": "${stateCode}",
      "name": "${stateName}",
      "type": "ADMINISTRATIVE_AREA_LEVEL_1"
    }
  ]
}`