IMPORTJSONAPI
IMPORTJSONAPI copied to clipboard
Concatenate strings and parsed data
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...