Wix Data Insert values into Address Field

[Jamie_Webb]

Question:
I have a Rest API where I’m exposing my own Booking Application. I have a function called addBooking. The source application collects information regarding Booking. Then a rest API call is made from the source application to my Site.
The issue I’m facing is that because the data hasn’t been collected using WIX Address Input field I need to using the WixData.Insert to add the Address info into a WIX CRM Table.

Does anyone have a working example of using the WIXData.Insert to insert a valid Address.
Each time I try when I go to the CRM it says it’s not a valid Address.

I’m inserting the address data in as a comma delimited string eg:

26 Main Road, Hockley, Essex, SS8 5AJ

[Pratham]

As per the $w(‘#addressInput’) documentation, the address needs to be set using a formatted property inside an object.

See the various examples here and try passing your address in a similar format. Not totally sure if it will, but might work.

Value | Velo

[Jamie_Webb]

Thank you but I’m not sure this answers my question. I really need to know the format that will be accepted by Wix Insert into a CRM Address field.
I’ve tried various formatted strings but nothing seems to be accepted.
I could really do with a working example of code for inserting into a CRM table. The value hasn’t come from an address input field, rather from a third party application with a number of fields collecting data related an address.

[Dan_Suhr]

this is the format when exported as a csv

{"subdivisions":[{"code":"NY","name":"New York","type":"ADMINISTRATIVE_AREA_LEVEL_1"},{"code":"New York County","name":"New York County","type":"ADMINISTRATIVE_AREA_LEVEL_2"},{"code":"New York","name":"New York","type":"ADMINISTRATIVE_AREA_LEVEL_3"},{"code":"US","name":"United States","type":"COUNTRY"}],"city":"New York","location":{"latitude":40.7391801,"longitude":-74.0091214},"countryFullname":"United States","streetAddress":{"number":"100","name":"Gansevoort Street","apt":"","formattedAddressLine":"100 Gansevoort St"},"formatted":"100 Gansevoort Street, New York, NY 10014, USA","country":"US","postalCode":"10014-1477","subdivision":"NY"}

[Pratham]

@Jamie_Webb

I really need to know the format that will be accepted by Wix Insert into a CRM Address field.

This is why I pointed you to the address input documentation. I know you are NOT using an address input but getting that data from elsewhere, but what I suggested was to see the format that the Address Input uses and try to parse your text into the same format before entering it into your CMS.

@Jamie_Webb

I could really do with a working example of code for inserting into a CRM table.

Which is why it is always recommended to search on the forum first for similar questions before posting your own. Chances are somebody has already faced the same issue before you and has found a working solution to it. All you need to do is to research thoroughly first.

Address Database field type

People, I solved it! I just haven’t got the time to post it here. Here is the thing, the Address Database Field is a JSON, so to save it to your dataset you need to format it as a JSON. First I created an object as a container to format the address: function createNewAddressObject(obj) { let { address_components } = obj // extract the address_components property of the JSON let fullAddress = { // this is the JSON object that is going to be pushed to the database city: "", loc…

The solution above seems to format the object into a valid address using an external API. If straightforward text-to-object parsing isn’t working, then you can take some inspiration from this one and customize it to fit your needs.