0

How can a create a function that calls this API URL of bitly https://api-ssl.bitly.com/v3/link/clicks to get the number of clicks of one given link.

When i call i get this: {"status_code": 200, "data": {"units": -1, "unit_reference_ts": null, "tz_offset": -5, "unit": "day", "link_clicks": 0}, "status_txt": "OK"}

I want to read a link in one cell and put the result in another cell.

I dont want to use import function, because it has a limit. You cant use more than x number on each sheet

Mogsdad
  • 44,709
  • 21
  • 151
  • 275
user3250094
  • 1

1 Answers1

0

The best tool I've found for parsing JSON is this ImportJSON script.

James Socol
  • 1,795
  • 10
  • 11