Automobile VIN Lookup Script

You can load the attachment up into your existing document, alternatively you can get this script, create a new form script and update the field ID’s at the top to match your field IDs. On Tap Forms 5.3 or later, form scripts are a third tab next to form and field settings.

The Utils.getJsonFromUrl() returns a JavaScript object directly. You don’t need to parse the JSON file, Tap Forms does that for you and creates a nested set of Javascript dictionaries and arrays.

The Google Books API response is a little convoluted, what you want is a few levels deep. You might want to look into grabbing a JSON formatter for your favourite web browser to help see the layering in the responses with a tree format.

Here’s something simple to get you further along:

function Json_Request() {
	let data = Utils.getJsonFromUrl('https://www.googleapis.com/books/v1/volumes?q=isbn:9780061143397');
	console.log(data['kind']);
	for (let i = 0; i < data['items'].length; i++)
	{
		let item = data['items'];
		let volume = item['volumeInfo'];

		console.log('Title: ' + volume['title']);
		console.log('Print Type: ' + volume['printType']);
		console.log('Authors: ' + volume['authors'].join(', '));
	}
}

Json_Request();

This is a form script I started, it’s intended to run from the editor and use the console to log out the data. You’d need to update it and change it to do what you want.

EDIT: Ok, I think I understand where you might have gotten stuck.

Javascript lets you use array syntax (e.g. the square brackets) to access dictionaries, arrays and also strings. To access a dictionary, you use a key lookup (e.g. data['items']); to access an array, you generally use numeric lookups (e.g. results[0]) and you can also access a string and it will give you the character at that offset.

Quick example of the string output using a form script as a vehicle:

var mystring = 'Test';
for (var i = 0; i < mystring.length; i++)
{
	console.log(mystring);
}

Will output the following in the console:

T
e
s
t

Because it’s treating the string as an array of characters instead of giving you an error. I get caught by this from time to time and it sometimes takes me a moment to realise what I’ve done.

If you find yourself hitting this then you’re probably iterating over a string instead of the array you were intending. Hopefully this helps.