How to create an import set table using a JSON file

KS18 · ‎01-03-2022

When importing, JSON files can be used, but when selecting files with loaddata,
JSON files cannot be selected.
How should I create the importset table?

Allen Andreas · ‎01-03-2022

Hi,

You can do that and build out the import set table using it via file (and then attachment as the "File retrieval method").

So example of a JSON file could be:

{
"user": {
    "firstName": "Rack",
    "lastName": "jackson",
    "gender": "man",
    "age": 24
}
}

Data source settings would look like:

Then you can test load records, in which the import table and fields are made and the import set looks like:

The above is all an example, please use what I've given and take it from there.

Please mark reply as Helpful/Correct, if applicable. Thanks!

Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

View solution in original post

Allen Andreas · ‎01-04-2022

Hello,

You can remove the first data source.

Please proceed with whatever you're trying to do as I've provided extensive details, real examples, and documentation.

You should be good to go now?

Please mark reply as Helpful/Correct, if applicable. Thanks!

Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

KS18 · ‎01-04-2022

I understand.

Thank you very much for your kind words.

Raj40 · ‎10-09-2024

Hey Allan,

I have followed all the steps and I have 100 records in json file but it is inserting only one record. How should we insert all the records into import set table