Extracting data from a JSON file using an API into Google Sheets, arranging in tabs, and create linking buttons.

This is the first part of a big analytical project that will require extensive coding in the coming weeks.

You need to be a JS developer, who understands the concept of clean and how to make a code run fast.

Overall Code Expectations:

Fast code is expected. Slow but working code does not mean you’ve completed the milestone

Payments are per milestones achieved and only after checked for quality, not hours spent

Well documented code is a must. I should be able to read and understand what’s been done there, everywhere.

Organized code. Line spacing, short functions, promises instead of chain callbacks, create different modules instead of one big long code file.

No hardcoding. AS we’re going to take many variables as numbers at the first part of the project, the values will be taken from admin panels and not straight from the code.

Klarecon might perform code QC to the code. If the senior coder believes that there’s some quality issues, or a smart, faster, or shorter way to achieve the same result, the coder will have to modify the code. Remember, if the app is working, but slow or anyway dysfunctional, it’s not considered as a job done.

Code should be DRY - Don’t repeat yourself

When data is sent through the code, or analyzed in the code, and the code fails or unable to complete the task - a proper error message will be passed to the sheet that specifies where the code failed

Code should not change the design of the sheet

Code is written in the latest version of JS that’s allowed by Google Sheets

If additional systems are required, or recommended, please state the need before writing unnecessary code.

The developer will sign an NDA since the Skynet portion of the portion is confidential

Google Sheets JavaScript JSON API Google APIs

Projektin tunnus: #29931027

Tietoa projektista