I am trying to build a spreadsheet that can pull AppAnnie mobile app top charts into the sheet based on choices of Country, Appstore and App Category.I am using instructions from this excellent blog post which is using a combination of a JSONImport google script as well as a modified AppAnnie Google script extension to provide authorisation  for the main function of building a URL with combinations from the Appannie API to pull your chosen data. Due to the format of the AppAnnie API documentation, defining App Categories are not URL-friendly:categories=Overall > Games is the recommended formatting. I have a feeling that this format is what is causing the JSONImport script to fail on me. If I use a more simple AppAnnie API example URL, I do get results, so the main auth and scripts are working.Is anyone able to check what is causing the issue, I have tried finding URL-encoding and whatnot, but can't get further. I have a google sheet made public with both above scenarios entered. One is working, and the one I want is not :-)Thanks in advance for any advise.
Something is broken when using JSONImport script to pull AppAnnie app topcharts via API
google spreadsheets