A couple of lines of JSTON code for Google Sheets

Cancelled Posted May 10, 2016 Paid on delivery
Cancelled Paid on delivery

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

Excel JavaScript JSON MySQL

Project ID: #10461505

About the project

3 proposals Remote project Active May 10, 2016

3 freelancers are bidding on average $40 for this job

Viqtor

Hi, can help. Will develop that script. Also need url with data for understanding it structure. Regards, Viktor

$55 USD in 1 day
(22 Reviews)
4.8
degea

I have very good idea of Google Sheets , I can definitely complete this task on time. Please take a look at my profile

$30 USD in 3 days
(0 Reviews)
0.0