Import data from JSON file

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 customer.name.

let customersJSON = Utils.copyTextFromClipboard();
let customers = JSON.parse(customersJSON);

for (let customer of customers){
	if (customer.name){
		console.log("Processing customer name: " + customer.name);
	} else {
		// missing customer name branch
	}
}

Hope this helps you get started.

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 = city.name;
        let country = city.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);
    }
    form.saveAllChanges();
}

Import_Time_Zones();

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.