Welcome to the Auth0 Community!
Thank you for posting your question. If you are exporting users in the CSV format you have to provide the full path to the object for the export:
{
//rest of user profile...
"app_metadata": {
"address": {
"street_address": {
"number": "1",
}
}
}
To get the number attribute value exported the field would need to be specified like below:
{
"connection_id": "<connection ID here",
"format": "csv",
"fields": [
{
"name": "user_id"
},
{
"name": "username"
},
{
"name": "app_metadata.address.street_address.number"
}
]
}
Alternatively, you can use the JSON object instead of the CSV to export the entire object or the list by just requesting the app_metadata/user_metadata.
You can read more about that here → Fields that can be Exported using the Bulk Export Tool
Thanks
Dawid