Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function testApi(){
- const url = "https://financialmodelingprep.com/api/v3/earning_call_transcript/AAPL?quarter=3&year=2020&apikey=demo"
- const res = UrlFetchApp.fetch(url)
- const data = JSON.parse(res.getContentText())
- const split = data[0].content.split(/\n/);
- const output = []
- split.forEach(line => { output.push([line])})
- SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Test').getRange(1,1,output.length,1).setValues(output)
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement