JobsManager Export Users malformed JSON

Help
1

When I use the JobsManager to export my users in JSON format the resulting file is not valid JSON. Each line of the file is an object but they are not contained in an array and are missing commas. Is this intentional? Seems strange to provide a JSON file that isn’t JSON at all.

3 Likes
2

I’ll bump this, as I ran into it as well. The result is like this:

{
    "email" : "user1@example.com",
     ....
}{
    "email" : "user2@example.com",
     ....
}{
    "email" : "user3@example.com",
     ....
}

In other words a blob with multiple root nodes, and really not following the JSON standard at all.
Is there any “hidden options” I can pass to the export job endpoint to get the result in standardized JSON?

3

Hi y’all,

This is by design. The export user job is in JSON compatible format:
https://auth0.com/docs/users/bulk-user-exports#json-compatible-format

It is actually a ndsjon file:
http://ndjson.org/

This is due to the size.

John