Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,344 questions
I get an error when trying to unroll multiple arrays
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 13%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHK%3C/text%3E%3C/svg%3E)
Håkan Champ Bondesson
20
Reputation points
I have the below structure and I want to unroll my data for two of the returned arrays. It's working fine to unroll one array (any of them) but when adding an additional "Unroll by" column I keep getting an error, which doesn't give much information:
and the error details on my notifications:
What am I doing wrong to get these two arrays flatten?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT 31,216 Reputation points Microsoft Employee2024-02-15T19:31:49+00:00 Hello
Håkan Champ Bondesson,Welcome to the Microsoft Q&A forum.
Could you please share your sample Json file?
-
Håkan Champ Bondesson 20 Reputation points
2024-02-19T08:22:01.5966667+00:00 {"statusCode":200,"statusMessage":"OK","responseDetails":{"consumerInfo":{"consumerCategory":"Person","consumerId":66666666,"consumerLanguage":"SV","consumerStatus":"Customer","creationDateTime":"2022-09-30T12:30:31","globalConsumerId":"8888888","market":"SE","sourceCountry":"SE","originalCreation":"2018-03-01T11:16:40"},"alternativeConsumerIds":[{"type":"ALT_ID_DMS_ID","value":"4444444444","active":true,"main":false,"countryCode":"SE","primaryKey":777777.0},{"type":"ALT_ID_GLOBAL_CONSUMER_ID","value":"8888888","active":true,"main":false,"countryCode":"SE","primaryKey":2222222.0},{"type":"ALT_ID_MY_VOLVO_ID","value":"5087f00c-c5ed-4790-ae00-9c5252967bec","active":true,"main":false,"countryCode":"SE","primaryKey":7777777.0},{"type":"ALT_ID_CDB_ID","value":"66666666","active":true,"main":true,"countryCode":"SE","primaryKey":4444444.0},{"type":"ALT_ID_RCXP_ID","value":"0013X000099grbUWWW","active":true,"main":false,"countryCode":"SE","primaryKey":11111111.0}],"consumerRelations":[{"type":"CUST_REL_USER_CHOOSER","consumerId":6666665,"startDate":"2021-12-29T00:00:00","primaryKey":12357.0}],"personDetails":{"dateOfBirth":"1999-07-15T00:00:00","firstName":"James Peter","gender":"Male","protectedIdentity":false,"hobbies":[],"houseHoldId":8888888,"maritalStatus":"Unknown","personalId":"4444444445","surname":"Bond","children":[]},"addresses":[{"active":true,"addressLine1":"2300 Sothern highway","city":"Valldown","country":"SE","main":true,"postalCodeNumber":"49333","statusType":"ADDR_STS_VALID_ADDRESS","type":"ADDR_HOME","startDate":"2022-01-12T00:00:00","primaryKey":2555555.0}],"contactDetails":[{"usage":"CONT_NO_USG_MOBILE","type":"CONT_MED_PHONE","active":true,"value":"+46709990090","primaryKey":222225.0},{"usage":"CONT_NO_USG_BUSINESS","type":"CONT_MED_PHONE","active":true,"value":"+46079990090","primaryKey":222226.0}],"contactPreferences":[],"emailAddresses":[{"usage":"CONT_NO_USG_BUSINESS","active":true,"value":"******@bond.com","primaryKey":222256.0},{"usage":"CONT_NO_USG_HOME","active":true,"value":"******@vbond.com","primaryKey":2055554.0}],"partnerRelations":[{"partner":{"countryCode":"SE","parmaPartnerCode":"XXX8D","partnerId":"0771","prefix":"D"},"startDate":"2019-06-18T00:00:00","type":"PARTN_CUST_REL_SELL_DEALER","primaryKey":77779.0}],"vehicleRelations":[{"endDate":"2022-04-19T00:00:00","startDate":"2003-04-28T00:00:00","primaryDriver":false,"type":"Owns","vehicle":{"id":"YV9LW88F2Y9999411","fyon":150007799,"category":"Volvo","modelYear":2000,"make":"VOLVO","model":"VEH_MODEL_875","productCode":"0156917999","productType":"PAG Vehicle","productOffering":"Volvo"},"primaryKey":11944444.0},{"endDate":"2020-10-19T00:00:00","startDate":"2019-09-23T00:00:00","primaryDriver":false,"type":"Drives","vehicle":{"id":"7XXXS25VDXX034999","fyon":640079400,"category":"Volvo","modelYear":2020,"make":"VOLVO","model":"VEH_MODEL_224","productCode":"0649979432","productType":"PAG Vehicle","productOffering":"Volvo"},"primaryKey":94444455.0},{"startDate":"2021-12-29T00:00:00","primaryDriver":true,"type":"Drives","vehicle":{"id":"YV9UZXXXDN1989999","fyon":660001299,"category":"Volvo","modelYear":2022,"make":"VOLVO","model":"VEH_MODEL_246","productCode":"0667231229","productType":"PAG Vehicle","productOffering":"Volvo"},"primaryKey":99994444.0}],"subscriptions":[],"sourceCode":{"createdBy":"4SXXX","updatedBy":"InternalSys"}}} -
Bhargava-MSFT 31,216 Reputation points Microsoft Employee
2024-02-20T19:18:44.48+00:00 I am looking for the Input Json and the your expected output to better understand the issue that you are facing.
-
Håkan Champ Bondesson 20 Reputation points
2024-02-21T06:43:01.1633333+00:00 The input json (retreived after the externalCall is the above and I would like to be able to flatten/unroll by more than one array. I want to unroll by:
-alternativeConsumerIds
- addresses
When adding an additional column (addresses) I get the above error which doesn't give any useful information at all.
Sign in to comment
Sign in to answer