A couple of lines of JSTON code for Google Sheets
$10-30 USD
货到付款
I am working on Google Sheets and am making JSON requests which give back multiple results.
This is the code I am using:
Result_a
=ImportJSON(CONCATENATE("[url removed, login to view]",C2,"&field_a=",A2,"&field_b=",B2,"&api=",$G$6),"/result_a","noHeaders")
Result_b
=ImportJSON(CONCATENATE("[url removed, login to view]",C2,"&field_a=",A2,"&field_b=",B2,"&api=",$G$6),"/result_b","noHeaders")
Part 1
I need to be able to streamline the above process, since it is calling the same JSON database each time for each result, I want to be able to get all the Results with just one call, and have each result (result_a, result_b, result_c etc.) displayed on the same row but in seperate columns.
Part 2
One of the results has multiple lines, and this is breaking the spreadsheet, I need that result to just return the first line and ignore the rest
项目ID: #10461505