Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
DatinexPeyman
Partner - Contributor II
Partner - Contributor II

Getting parts of the contact's adress like city, street etc (Qlik Web Connector, Outlook 365)

Hello dear qlikers,

i read the contacts from outlook 365 using "qlik web connectors". For adresses like business adress or private adress i get all the parts as a concatenated comma seperated list. From MS documentaion i know that the adresses have the following structure:

{
"city": "string",
"countryOrRegion": "string",
"postalCode": "string",
"state": "string",
"street": "string"
}

Is there anyway to get this parts separatly? Or determine what is the postal code in this string?
Many thanks for any idea in advance!

Best Regards
Peyman

 

 

Labels (1)
2 Replies
Jay_Brown
Support
Support

Hello Peyman,

Retrieving only postalCode is not available at the connector level but you should be able to use Resident Load to work around this:

let vQwcConnectionName = 'lib://OutlookConnector';

Test01:
LOAD
displayName as Contacts_displayName,
businessAddress as Address
FROM [$(vQwcConnectionName)]
(URL IS <your webconnectors url, etc>, qvx);

ResTest:
Load *,
SubField(Address,',',1) as Street,
SubField(Address,',',2) as City,
SubField(Address,',',3) as State,
SubField(Address,',',4) as Country,
SubField(Address,',',5) as PostalCode
Resident Test01;

DROP Table Test01;


Note that this may require some manual standardization of your contacts, I had some other country codes that needed to be changed.

Does this help?

Best regards,

--Jay

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.
DatinexPeyman
Partner - Contributor II
Partner - Contributor II
Author

Hello Jay,

thank you for you answer.

It is not the solution, becuse if you have no Street in your Address, the City would be the first part of the Address and so on ...

Wish you a nice Qliking time 😉

 

Regards

Peyman