Bablosoft

Json выражения

Поддержка

  • B

    json path

    Поддержка
    0 Votes
    2 Posts
    347 Views
    Q

    @barakobama123 mails[?(@.status1=='new')].from_login

  • T

    Работа с json

    Поддержка
    0 Votes
    3 Posts
    778 Views
    FoxF

    @Teror2 said in Работа с json:

    Методом тыка вышло так

    var data=JSON.parse(JSON.stringify([[PARSED_JSON_VALUES]]));
    var x;
    for (i in data) {
    x += data[i].id + ",";
    }
    log(x);

    PS теперь задумался, а зачем мне нужно было "Получить все значения", если можно сразу отправить переменную в js

    PSS* вышло примерно так:
    var data=JSON.parse([[SAVED_CONTENT]]);
    var array=[];
    for (i in data.data) {
    if (data.data[i].name=="Нужное имя"){
    array.push(data2.data[i].id);
    }
    }
    log(array.join(","));

    В первом сообщении вы указали, что вам нужна строка вида

    id=22,id=25,id=27

    ваш код возвращает строку только с результатами, без текста "id="

    @Teror2 said in Работа с json:

    Получил get запросом набор данных json Действие "Получить все значения" собрал лишь нужные значения
    в xpatch указал: data[?(@.name=="Нужное имя")]

    Теперь мне нужно весь список превратить в одну строку
    из набора данных получить data.id, чтоб вышла строка вида
    id=22,id=25,id=27

    Правильно ли я понимаю, нужно "Выполнить код" и на js присвоить переменной список значений, далее уже как мне нужно обработать этот массив?

    Без примера строки json вам не получится помочь. Кстати вы могли в самом выражении указать необходимое свойство:

    data[?(@.name=="Нужное имя")].id

    а полученный массив перевести в строку действием "Объединить в строку":

    eac9c4f1-d7c3-4157-b485-80867db0d1c7-изображение.png

  • G

    Помогите вытащить кусок текста рег выражения

    Moved Поддержка
    0 Votes
    4 Posts
    588 Views
    G

    @perhorovich состав всегда есть канце текста всегда разные

  • L

    Json целиком с добавлением значения

    Поддержка
    0 Votes
    23 Posts
    2434 Views
    L
    {"list":[{"id":739272,"requests":[{"name":"Vitaly","amount":2.38}],"note":null,"botRequestBy":null,"nonlistSong":null,"donationAmount":2.38,"createdAt":"2020-02-02T18:27:28.762Z","prevId":null,"song":{"title":"Kephallonia Island - Assassin's Creed Odyssey","artist":"","createdAt":"2019-02-05T23:05:23.000Z","attributeIds":[]},"songId":114436,"streamerId":1856,"position":1},{"id":739562,"requests":[{"name":"NIGHTMARE","amount":5.84},{"name":"1","amount":1}],"note":null,"botRequestBy":null,"nonlistSong":null,"donationAmount":6.84,"createdAt":"2020-02-02T21:53:22.567Z","prevId":739272,"song":{"title":"Wind in the Dunes - Metro Exodus","artist":"","createdAt":"2019-11-21T18:40:34.979Z","attributeIds":[]},"songId":226298,"streamerId":1856,"position":2},{"id":739566,"requests":[{"name":"SmashDtrash","amount":4.76}],"note":null,"botRequestBy":null,"nonlistSong":null,"donationAmount":4.76,"createdAt":"2020-02-02T21:57:10.504Z","prevId":739562,"song":{"title":"Overture - Metro Exodus","artist":"","createdAt":"2019-11-21T18:32:22.138Z","attributeIds":[]},"songId":226290,"streamerId":1856,"position":3},{"id":739571,"requests":[{"name":"Guslik","amount":3.17}],"note":null,"botRequestBy":null,"nonlistSong":null,"donationAmount":3.17,"createdAt":"2020-02-02T22:01:12.589Z","prevId":739566,"song":{"title":"Storm Summer - Vivaldi","artist":"","createdAt":"2020-01-14T14:54:34.318Z","attributeIds":[]},"songId":254626,"streamerId":1856,"position":4},{"id":739465,"requests":[{"name":"Joker’s Grin","amount":2.38}],"note":null,"botRequestBy":null,"nonlistSong":null,"donationAmount":2.38,"createdAt":"2020-02-02T20:50:45.770Z","prevId":739571,"song":{"title":"Once, There Was an Explosion - Death Stranding","artist":"","createdAt":"2019-11-21T19:17:22.862Z","attributeIds":[]},"songId":226357,"streamerId":1856,"position":5},{"id":739483,"requests":[{"name":"Антонио","amount":1.92}],"note":null,"botRequestBy":null,"nonlistSong":null,"donationAmount":1.92,"createdAt":"2020-02-02T21:03:29.395Z","prevId":739465,"song":{"title":"Main Theme - Terminator 2","artist":"","createdAt":"2020-01-30T14:50:17.878Z","attributeIds":[]},"songId":260495,"streamerId":1856,"position":6},{"id":738320,"requests":[{"name":"Fennel Dove","amount":1}],"note":null,"botRequestBy":null,"nonlistSong":null,"donationAmount":1,"createdAt":"2020-02-01T20:28:44.165Z","prevId":739483,"song":{"title":"Installation - Halo Combat Evolved","artist":"","createdAt":"2020-01-30T14:28:25.426Z","attributeIds":[]},"songId":260482,"streamerId":1856,"position":7},{"id":739518,"requests":[{"name":"redfantomas","amount":1}],"note":null,"botRequestBy":null,"nonlistSong":null,"donationAmount":1,"createdAt":"2020-02-02T21:32:15.705Z","prevId":738320,"song":{"title":"Gladiator - Hans Zimmer - Gladiator","artist":"","createdAt":"2020-01-16T16:49:29.353Z","attributeIds":[]},"songId":254949,"streamerId":1856,"position":8},{"id":735113,"requests":[{"name":"злодейка","amount":0.88}],"note":null,"botRequestBy":null,"nonlistSong":null,"donationAmount":0.88,"createdAt":"2020-01-30T18:53:11.566Z","prevId":739518,"song":{"title":"Phoibe the Orphan - Assassin's Creed Odyssey","artist":"","createdAt":"2019-11-21T18:06:39.751Z","attributeIds":[]},"songId":226280,"streamerId":1856,"position":9},{"id":731963,"requests":[{"name":"Snake Eyes","amount":0.8}],"note":null,"botRequestBy":null,"nonlistSong":null,"donationAmount":0.8,"createdAt":"2020-01-28T18:29:34.660Z","prevId":735113,"song":{"title":"Ashina Clan - Sekiro: Shadows Die Twice","artist":"","createdAt":"2019-11-21T18:46:47.414Z","attributeIds":[]},"songId":226304,"streamerId":1856,"position":10},{"id":732216,"requests":[{"name":"zelya","amount":0.8}],"note":null,"botRequestBy":null,"nonlistSong":null,"donationAmount":0.8,"createdAt":"2020-01-28T20:30:46.153Z","prevId":731963,"song":{"title":"River Flows In You - Yiruma","artist":"","createdAt":"2019-12-07T17:04:17.350Z","attributeIds":[]},"songId":232511,"streamerId":1856,"position":11},{"id":734998,"requests":[{"name":"IceQueen","amount":0.79}],"note":null,"botRequestBy":null,"nonlistSong":null,"donationAmount":0.79,"createdAt":"2020-01-30T17:31:10.722Z","prevId":732216,"song":{"title":"Teardrops Pt. 2 - Metro Exodus","artist":"","createdAt":"2019-11-21T18:41:23.107Z","attributeIds":[]},"songId":226299,"streamerId":1856,"position":12},{"id":735100,"requests":[{"name":"LexusGTXXX","amount":0.79}],"note":null,"botRequestBy":null,"nonlistSong":null,"donationAmount":0.79,"createdAt":"2020-01-30T18:45:11.064Z","prevId":734998,"song":{"title":"Кукла Колдуна - КиШ","artist":"","createdAt":"2019-12-07T14:22:59.437Z","attributeIds":[]},"songId":232456,"streamerId":1856,"position":13},{"id":738111,"requests":[{"name":"NineTees","amount":0.79}],"note":null,"botRequestBy":null,"nonlistSong":null,"donationAmount":0.79,"createdAt":"2020-02-01T18:36:57.103Z","prevId":735100,"song":{"title":"Hunt or Be Hunted - The Witcher 3","artist":"","createdAt":"2019-02-04T16:56:27.000Z","attributeIds":[]},"songId":113958,"streamerId":1856,"position":14},{"id":738326,"requests":[{"name":"Night Train","amount":0.79}],"note":null,"botRequestBy":null,"nonlistSong":null,"donationAmount":0.79,"createdAt":"2020-02-01T20:32:29.939Z","prevId":738111,"song":{"title":"Cold Welcome - Metro Exodus","artist":"","createdAt":"2019-11-21T18:37:21.107Z","attributeIds":[]},"songId":226295,"streamerId":1856,"position":15},{"id":739396,"requests":[{"name":"LittleTickle","amount":0.79}],"note":null,"botRequestBy":null,"nonlistSong":null,"donationAmount":0.79,"createdAt":"2020-02-02T19:51:31.485Z","prevId":738326,"song":{"title":"The Trail - The Witcher 3","artist":"","createdAt":"2019-02-04T16:45:02.000Z","attributeIds":[]},"songId":113943,"streamerId":1856,"position":16},{"id":739406,"requests":[{"name":"Red Rhino","amount":0.79}],"note":null,"botRequestBy":null,"nonlistSong":null,"donationAmount":0.79,"createdAt":"2020-02-02T19:55:33.753Z","prevId":739396,"song":{"title":"Markos - Assassin's Creed Odyssey","artist":"","createdAt":"2019-02-05T23:06:45.000Z","attributeIds":[]},"songId":114439,"streamerId":1856,"position":17},{"id":739459,"requests":[{"name":"воин","amount":0.79}],"note":null,"botRequestBy":null,"nonlistSong":null,"donationAmount":0.79,"createdAt":"2020-02-02T20:46:49.556Z","prevId":739406,"song":{"title":"Exodus Blues - Metro Exodus","artist":"","createdAt":"2019-11-21T18:38:19.609Z","attributeIds":[]},"songId":226297,"streamerId":1856,"position":18}],"status":{"songsPlayedToday":0}}

    Вот так выглядит весь объект из массива, с которым я работаю.

  • L

    Json массив с [ в начале, с обработкой slice, появляется проблема

    Поддержка
    0 Votes
    5 Posts
    1100 Views
    L

    Спасибо большое, DrPrime, решился вопрос.