Unable to import JSON

[lizzie-tersano]

I have been trying to import user data for testing purposes and the user-import-export extension refuses to accept any of the json files. I keep receiving a “An error occured while uploading the file: Bad Request”. Also, “occurred” is misspelled in the error message .

I have:

• Fully read the document at Bulk User Import Database Schema and Examples.
• Reduced the import to only have user_id, password_hash, email, email_verified, and app_metadata.

When that did not work, I copy and pasted the basic example at (Bulk User Import Database Schema and Examples) and it proceeded to return the exact same error.

[dan.woda]

Hi @lizzie-tersano,

Welcome to the Auth0 Community (and thank you for the spell check!).

Can you please post an example of the request you are making? Be sure to remove sensitive data. Thank you!

[lizzie-tersano]

Hello! Thank you for taking the time to get back to me. This is the data format of the json file I attempted to import.

[{
“user_id” : “some mongo id number”,
“email”: “some email address”,
“email_verified”: true,
“app_metadata” : {
“roles” : [“admin”]
},
“password_hash” : “$2b$10$6U.VtIlOegEmhfzPHrTsCO/YhPWGWYeKZOlM5YuU1YxGWY7hBo/sW”
}]

Thanks!

[dan.woda]

I am getting a parsing error when I try to validate that JSON.

If you think that is a result of the editor, feel free to use code blocks, or send me the file directly.

[lizzie-tersano]

It’s not the Json itself, the embedded editor keeps changing the straight double ticks to slanted ones. Anyways, here is the .txt file as this editor does not allow the import of .json files.
user.txt (253 Bytes)

Thank you again for the help!

[dan.woda]

Great, thanks for the added info.

I was able to successfully import that user, the only change I made was the file extension (as you mentioned).

Can you confirm that you have enabled an application for the connection you are importing to? It’s mentioned in the docs, but it’s very small.

[lizzie-tersano]

It should be, I think. I’ll retrace my steps to see and I’ll get back to you as there appears to be a 504 gateway error when attempting to log into the dashboard. Thank you for the help, much appreciated!

[dan.woda]

Sounds good! Please let me know if you there is anything I can do.

[lizzie-tersano]

I got it to work! Don’t know exactly why, so this is what I did:

• Defined roles and assigned permissions
• Enabled RBAC Settings

Thank you for taking the time out of your day to help!

[dan.woda]

Great! Glad you got it working.

One troubleshooting hint; if you run into issues with the import extension, using the API directly can narrow down the potential problems.

Let us know if you run into anything else!