Importing JSONL file to datastore - getting errors

[emilioi]

Trying to upload to datastore but then get the import to work for the agent. This is the error im getting:

Error sample

invalid JSON in (google.cloud.discoveryengine.v1main.Document), near 1:9 (offset 8): no such field: 'test'

[thanh-le-qode · Accepted solution]

The same error, did you fixed that?

[mith · Accepted solution]

how did you solve it?facing the same error 😕

[benggy · Accepted solution]

Same issue here, it used to work with the same jsonl file.

[thanh-le-qode · Accepted solution]

The same error, did you fixed that?

[mith · Accepted solution]

how did you solve it?facing the same error 😕

[benggy · Accepted solution]

Same issue here, it used to work with the same jsonl file.

[benggy · Accepted solution]

Why are you mark my comment as a solution. If it's resolved, how did you fix it?

[jinfante]

Same issue encountered. Did anyone able fix it?

[devdevdev]

You need to add the JSON data inside "json_data" field in string type.

Let us suppose your individual JSON document is {"test": "value"}

JSONL file should be like:

{ "id": "0", "json_data": "{\"test\" : \"value\"}" }

[ranaa_fh]

this worked for me! thank you

[Nabeel_753]

Hello all,

I am still encountering the following error message:

"invalid JSON in google.cloud.discoveryengine.v1main.Document, near 1:12 (offset 11)."

I have a Big Query table with basic columns such as Team, Team Lead, and Email Address. I exported this table in Newline-delimited JSON format to Google Cloud Storage, and the JSON file is now visible in my bucket. On the Agent Builder platform, I created a chatbot and attempted to import the JSON file from the bucket. However, when I import the file, I receive the above error message.

I would greatly appreciate your assistance, as I have been struggling to resolve this issue.

Thank you for your time.

[Nab_4697]

Hi,

Any guidance on the below issue will be appreciated.

I am still encountering the following error message:

"invalid JSON in google.cloud.discoveryengine.v1main.Document, near 1:12 (offset 11)."

I have a Big Query table with basic columns such as Team, Team Lead, and Email Address. I exported this table in Newline-delimited JSON format to Google Cloud Storage, and the JSON file is now visible in my bucket. On the Agent Builder platform, I created a chatbot and attempted to import the JSON file from the bucket. However, when I import the file, I receive the above error message.

I would greatly appreciate your assistance, as I have been struggling to resolve this issue.

Thank you for your time.