Import data from JSON file

Viewing 7 reply threads
  • Author
  • February 4, 2023 at 5:54 AM #48834

    Chris Ju

    Hi everyone,

    I would like to import data from a JSON file. The fields should be filled accordingly. Here is an example of a JSON file with one record. Retrieving the entire file is no problem with

    var data = Utils.getJsonFromUrl(url);

    … but I want to fetch them one by one and populate the fields in the form’s record.

    I think it is easy, but i’m still not handy with java script.

    Easyest way would be from the import dialog, but that doesn’t work.


    February 4, 2023 at 6:02 AM #48835

    Chris Ju

    … Not all data records have the same fields and if i export multiple objects the JSON file looks like this (for two objects):


    February 4, 2023 at 11:17 AM #48836

    Daniel Leu

    What a coincidence, I’m working on getting JSON data into TF right now as well. My data is on the clipboard. So I import it from there. Next I translate it into a javascript data object. Then loop over the different entries.

    For you, since not all records have the same fields, you need to check for valid content like I do with

    let customersJSON = Utils.copyTextFromClipboard();
    let customers = JSON.parse(customersJSON);
    for (let customer of customers){
    	if ({
    		console.log("Processing customer name: " +;
    	} else {
    		// missing customer name branch

    Hope this helps you get started.

    February 5, 2023 at 2:21 AM #48838

    Chris Ju

    Thanks, that’s useful. But with my little experience with java script it isn’t possible for me to get a reliable result. Maybe someone else has solved that in the past and could give some hints.

    Especially if one have a JSON file with multiple “datasets”, looping through the “datasets” and adding a new entry in TF for every “dataset” is difficult to understand for me :-( … but i’m working on it…

    @Brendan (if you read this): Wouldn’t it be easier to introduce an import option for JSON files? JSON is also only a table in some way… or am I thinking wrong?

    February 5, 2023 at 2:43 PM #48839


    Hi Chris,

    Well, what you probably have is an array of dictionaries in your JSON.

    So your data variable is probably just that. So you need to iterate over the array and pick out the values, create a new record for each entry in the JSON file and set the field value on it.

    Here’s an example script that does that to import a file of time zones.

    function Import_Time_Zones() {
        var time_zone_name_id = 'fld-1b8bca6459724faabec0d3f7a1b3e4e4';
        var country_id = 'fld-69acd4190b974d678a6e662308d580d7';
        var name_id = 'fld-4dc0850299c64960b480a3593bbdfad0';
        let url = 'file:///Users/brendan/Desktop/CitiesAndTimeZones.json';
        let cities = Utils.getJsonFromUrl(url);
        for (let index = 0; index < cities.length; index++) {
            let city = cities[index];
            let name =;
            let country =;
            let time_zone_name = city.timeZoneName;
            let newRecord = form.addNewRecord();
            newRecord.setFieldValue(name_id, name);
            newRecord.setFieldValue(country_id, country);
            newRecord.setFieldValue(time_zone_name_id, time_zone_name);

    I’ve attached the JSON file if you want to play around with it.

    One very helpful technique when dealing with JSON files, is use the JSON.stringify() function to see what kind of data you get from your JSON file.

    February 5, 2023 at 2:45 PM #48840


    Hmm… seems the JSON file didn’t get attached. Maybe I have to zip it.

    You must be logged in to view attached files.
    February 5, 2023 at 9:56 PM #48847

    Chris Ju

    Hi Brendan, thanks for that example script. It works, if i get the JSON data from clipboard.

    Using your original script to get the JSON data from file:


    let url = 'file:///Users/jur/Desktop/CitiesAndTimeZones.json';
    let cities = Utils.getJsonFromUrl(url);

    for (let index = 0; index < cities.length; index++) {


    results to:

    Import Time Zones: TypeError: undefined is not an object (evaluating 'cities.length'), line:(null)

    February 6, 2023 at 12:43 AM #48849


    Make sure that you set the Script folder on the Preferences window to your Desktop folder before you run the script. It’s probably not able to read the file due to security restrictions in macOS.

    February 6, 2023 at 12:49 AM #48850

    Chris Ju

    Some things are so simple…


Viewing 7 reply threads

You must be logged in to reply to this topic.