A couple of lines of JSTON code for Google Sheets

Cancelado Publicado hace 7 años Pagado a la entrega
Cancelado Pagado a la entrega

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

Nº del proyecto: #10461505

Sobre el proyecto

3 propuestas Proyecto remoto Activo hace 7 años

3 freelancers están ofertando un promedio de $40 por este trabajo

Viqtor

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

$55 USD en 1 día
(22 comentarios)
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 en 3 días
(0 comentarios)
0.0