Getting app_metadata when using hashes

[florian.van.bochove]

Hello,

I’m having trouble exporting specific elements from the app_metadata using the import/export extension. I can get the email and login count without a problem but when I want to retrieve the fields from inside the app_metadata I’m running into a problem. Our metadata looks like this:

{
  "hashes": [
    {
      "type": "client",
      "hash": "9c6732f13bfe1dd9e743a7f7c637a96f4437364a77eb9699fa447a59b2643dd5",
      "premium": false
    }
  ]
}

Using app_metadata.type doesnt work (presumably because of the “hashes”). How do I grab the elements inside the hash? I tried something like app_metadata.hashes.type but that still gave me blank columns.

Thanks in advance

[rueben.tiow]

Hi @florian.van.bochove,

Welcome to the Auth0 Community!

After some tests and looking closely at your app_metadata, I found that you need to set the hashes property as an object.

{
    "hashes": {
      "type": "client",
      "hash": "9c6732f13bfe1dd9e743a7f7c637a96f4437364a77eb9699fa447a59b2643dd5",
      "premium": false
  }
}

Once you have made these changes, you can export your users app_metadata.hashes.client without issues. I can confirm after testing on my side as well.

Please let me know if there’s anything else I can do to help.

Thank you.