IMPORTJSONAPI icon indicating copy to clipboard operation
IMPORTJSONAPI copied to clipboard

Concatenate strings and parsed data

Open Darkar25 opened this issue 4 years ago • 0 comments

i have this formula =IMPORTJSONAPI("https://api.firetype.ru/getFakeSellers.php";"$[*]";"user_id,nickname,vk,clan") the fourth column is json object and the third is number... i want something like =IMPORTJSONAPI("https://api.firetype.ru/getFakeSellers.php";"$[*]";"user_id,nickname,'https://vk.com/id'+vk,'['+clan.tag+'] '+clan.name") so clan name and tag will be in the same cell and vk column will become a url...

Darkar25 avatar Nov 15 '21 10:11 Darkar25