I'm embarrassed to ask: How do you write an API

bertodal

I have a report that beautifully aggregates data from 70+ sheets. I need one column from that report to populate a helper sheet that I have:

Source Sheets > Report > Helper Sheet

As the report grows with data, I want the helper sheet to grow with it without manual intervention. Ergo, the API question.

Here's what I know (not much)… somewhere online I found API code that pulls data from a report: GET /reports/{reportId}

and into a helper sheet:

PUT /sheets/{sheetId}/rows

I have a Smartsheet API Token - all set there.

But where does one start writing the code for this? Do I use Smartsheet's Software Development Kit? We don't have a license to Bridge. Or can we write the API outside those tools (Windows Start > Right Click > Run > etc.)?

Thank you in advance.

marc4

You can use Data Shuttle to export all or some of the source sheet and then use Data Shuttle to import the column you want into the helper sheet. No API needed.

/marc