A couple of lines of JSTON code for Google Sheets

已取消 已发布的 7 年前 货到付款
已取消 货到付款

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

项目ID: #10461505

关于项目

3个方案 远程项目 活跃的7 年前

有3名威客正在参与此工作的竞标,均价$40/小时

Viqtor

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

$55USD 在1天里
(22条评论)
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 在3天内
(0条评论)
0.0