Bablosoft

json path

Поддержка

  • R

    Конвертировать из json/netscape в bas cookies

    Поддержка
    0 Votes
    2 Posts
    1294 Views
    FoxF

    @rdbltz said in Конвертировать из json/netscape в bas cookies:

    Может кто подсказать каким образом сделать конвертер из каких либо куков в bas cookies|?

    смотрите тему "Лайфхаки"

  • G

    Получить значение из Json в названии свойства которого содержится символ точка

    Поддержка
    0 Votes
    6 Posts
    854 Views
    FoxF

    @gomeapat said in Получить значение из Json в названии свойства которого содержится символ точка:

    Есть на вход вот такой вот json не обходимо из него получить свойство с именем orderValue.b64
    Для получения объекта result в кубике получить значение достаточно написать
    .result
    А вот как из него получить свойство orderValue.b64 в имени которого содержится точка не понятно
    Как я только не пытался и так писал .result["orderValue.b64"] и вместо значение orderValue.b64 пытался заменить его переменной не работает.

    "{"jsonrpc":"2.0","result":{"captcha_alphabet":"АИЖКМНПРСУФЦЧЬЯ","captcha_len":6,"orderId":"e1a967c4-9a81-474e-8c40-f5602f6f8c89","orderValue.b64":"\/9j\/4AAQSkZJRgABAQEAYABgAAD\/\/gA+Q1JFQVRPUjogZ2QtanBlZyB2MS4wICh1c2luZyBJSkcgSlBFRyB2ODApLCBkZWZhdWx0IHF1YWxpdHkK\/9sAQwAIBgYHBgUIBwcHCQkICgwUDQwLCwwZEhMPFB0aHx4dGhwcICQuJyAiLCMcHCg3KSwwMTQ0NB8nOT04MjwuMzQy\/9sAQwEJCQkMCwwYDQ0YMiEcITIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIy\/8AAEQgAPAEsAwEiAAIRAQMRAf\/EAB8AAAEFAQEBAQEBAAAAAAAAAAABAgMEBQYHCAkKC\/\/EALUQAAIBAwMCBAMFBQQEAAABfQECAwAEEQUSITFBBhNRYQcicRQygZGhCCNCscEVUtHwJDNicoIJChYXGBkaJSYnKCkqNDU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6g4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2drh4uPk5ebn6Onq8fLz9PX29\/j5+v\/EAB8BAAMBAQEBAQEBAQEAAAAAAAABAgMEBQYHCAkKC\/\/EALURAAIBAgQEAwQHBQQEAAECdwABAgMRBAUhMQYSQVEHYXETIjKBCBRCkaGxwQkjM1LwFWJy0QoWJDThJfEXGBkaJicoKSo1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoKDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uLj5OXm5+jp6vLz9PX29\/j5+v\/aAAwDAQACEQMRAD8A9\/ooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKw9f8Y+HPCyM2taxaWjhA\/ks+6VlLbQVjXLsM55APQ+ho8U+KdN8KaNc3t7dWiTpbyy21tNcrE1yyLnYmeSScDgH7w4r5I0DSNa+KPjxbee8kkvL1zNd3sqFxEgHLEDgADCqOBkquQMUAep+JP2j3j8uHw5pMDyLjzri7ZmjY8hhGo2sV+6Q7bTjOUBrzC9+IPiz+2F1G+Nj\/AGn+7nW5n0a0877qtG4Yxbvu7Sp9MY7V9N+F\/hV4Q8JojWmlx3V2jq4vL4LNKGViVKkjCEZ6oF6DOSM15R+0b4XaDVNP8UQRxiC5QWdztRVPmrlkZjnLFlyOnAiHPIFAHu\/h7xDpvifRoNU0u5jmglRSyq6s0TFQ2x9pIVwGGRnitSvA\/gRPpviDw\/c6RcSyW+taW5a0urdlhnW2c7goYcyIspdmRwyZdMg8Aeuf8InE376bWdclvuouv7QdMMPunyU2wcccGPacfMGycgHQUVz\/APwiv2j\/AJCWva5fbf8AV\/6Z9k2ev\/HsIt2ePvbsY4xk50NM0yXTfNVtUvryFsCKO7KN5CjPAYKHbgjl2ZjgHOckgGhRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRXP8AifxpoXg77K2u3f2WG53iOTaXyy442rlzweoUqMYJBKhvI\/GPxv8ABvinwdquitpesl7q3ZYvMjjVVlHzRsSsucBwp79Oh6UAe4abq2m6zbtcaXqFpfQK5RpLWZZVDYBwSpIzgg49xVyvlD4L+OL3QfFVjo1zq8Fl4enlmmulnEaJv8kgEyMMryiDqP1r6voA8X+FXxg1jxt4tk0jWYdKtozaPLB5CujySKy\/KNznPylzgDPy56A17RXyR4r1C8+Hfx01bU7AwXV1DdyXKCeM7P8ASIyxUgMCcCUjORnGfaugs\/HfxO8YylzpmuSaTfbY4F0NBZorhgMi5aKQhcq27LDqckAEUAfS9Z+ma7o+t+b\/AGTqtjf+TjzPslwkuzOcZ2k4zg9fQ18+al8D\/G\/iK4W7uNakndEEQbXZiJwAScL5bzjZzx8wOd3yjgm5+zhHrFpq2p79NnTSL+0Eq3rwOEeSKTaFV\/un78mRyfl7YNAHv99f2emWcl5f3cFpax43zTyCNFyQBljwMkgfjVivO\/jJpur634Oj0nTGjgguLhTeXMxHlrGvKpgAyM7y+WFEasSRjjOD4hpWgfFTwdZW+p+Hl1J9NnfzbdtPb7RFOHTiUwcnBUA5dAR8ucHAoA+q7++t9M065v7yTy7W1ieaZ9pO1FBLHA5OAD0rwDxD41+JXjq8Fl4asJ9F026+exV5UtLm9jwHDK8jAtgLuPlcAPhiwIJ5O5+OPivUPDFzo9\/9kmlkQeXfpEEnjcSK4fj5MgAgFVUqdrA5XnpP2edb05fFGsxanceZrep7Ps0kqM8kuBJJN+8wcZwrHJGSB1IoA4\/xP8KPGOh+HJvFOueQcy5uka58ydC743ueVbLEdGY\/MMjriT4Ja+ug\/E2xWVo1g1FGsXZlZiC5BQLjoTIqDJyME9Oo+q9di87w9qcX9o\/2bvtJV+3btv2bKH95nIxt+9nI6dRXxh\/bGj6n\/wAhnSfKuDx9s0rZb9eNzwbfLbaMYVPKzg7mJO4AH2\/XL\/EPwwni7wNqel+R510YjLZgbQwnUZTDNwuT8pPHyswyM14x4T+JXiCK1ufDuna7Pr9\/d2k81hcTWzNJaGOKSUIysN0sz427dzIhCbWkGVFfwd4h8Y+NLzxD4evvEmuWWty+XMpgtslBAHEkIXdGtuzMY\/mygJXaxy3IByfw41q+8A\/E2xGowSWIldbO+iux5JSKQr8zbxlQp2P2yF6gGvsOvlzxL4f1Lwn4VvbPxvpUeqEanA1tqkM7Cd1mSd5FjndTgCRMlGQ8yO2Msrj3f4ceKLHxZ4Ksbyxku2Nui2twLt98olRVzufADkghtwAzu5AOQADrKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAPki\/hv\/AIx\/GG5hs7rNrLK6Q3HlyGOC0jyFfaeVyMHB2gvJ\/Durt\/HHw18K+BPBeqXLaFPqLCLbZagbmUPHK5C4mVTs+UtuVtoVtuxsNtaSh4D0C9+FXxOnk16\/0qy0x4pLcT3d3Gss8TSBY3SJXLLl1UksNqqHyRitf9ozxFZy6Ho+i20sE8kl3JcyNHMGMXlbotpUerM4zxgxsOTnAB88V6R8O\/jDqngOzl06W1\/tTTDlobd5vLMDk5JVtrfKecrjryMZbd6X4O+CfhfWfhvpU+rWsi6pe263DXtpcuGCu29AFbKZ2FVPynvj1ryzT9E0fUfjbYaP4ct\/tmkRahDHtndJBPHCFMzk52srbJH44IOABkLQBh+M\/FWteNtUTXtYhjQMn2WHyIikShMMUUnJJBk3HJJG8dBgV7\/+zxqrXvw+uLCW5jkewvXSOEbd0UThXGQOcFzLgn0I7YGf8cfAekW3gP8AtbSNOtLF9PuEaRIMxIY3Oxtsa\/JvLGLLYBIQDPAFcp+z9rlxY6jq+madpH226niW6ndrwRfuoiFCxoUIMhMp+86qeASuCSAfS9fPH27S9F\/aQ3alb3w1VtQ8tZoLnz4ZBPHsiUo4DR4SVCxDsAUIVQpG32f\/AISHVP8AoTNc\/wC\/1l\/8kV4Z8VYraL4g2Wuvb6l4W1aRIriG61CNLi3mliOAx8ppNhVVQYAfcSuVQfMwBofFPSrb4heOtNg0S21Ke4iuF0y+vYdk0FoiysGZ4lzIpDM\/zSFARGdu4HcPoOvnz4YeKF1Dx1quq61pmjWcVmknmz2GnNNtuJZWZp2ugJNqbfNBZpVTaRgYBI9\/gnhureK4t5Y5oJUDxyRsGV1IyCCOCCOc0Acv498MaRrXhrVLq68P2mqahDZSG23QkysyAuiKyESYLdlYZyR3r5Y8L+BPFevXF7LoNrINQ0i4iWWIzC3nhcl8MNxXBVoyDyCCRx1x7X+0D4ivLTTtI0PSZZ1vpZW1CQ2kxEkccALAlV525y+44AMJPbIsJrusaR8AbW81HVfI1\/V4hDbXV7cOQzSAiIiRTiJjAoIYlVD\/ADOQSxIB45beDvFXjHxBbWGs6zHFrUyFLe31m6le4KqGcgqFdogBlgJNm4Nld2TUfjz4f6x8NdcgeO4nntR5cttqcMLxBZOSF3chZAUJADE4weOg9H\/Z+8H6ppfiHV9X1G2nto0tFt4C0WY7kSOGLxyg7XUeUOVyCHBBxjPcfGWR9M8Lwa9DYfams5fIuT9oaPbaykBxtDbXy6xDa6SL6owzQB5p8cPG0PiPw14Rhs7iMJeW51K5tUIkEbEBEHmY5Kt56EDHIOQOK9D+CM76z4e1LxLeaZBaalqN2EnuII2jW8EaACUqTt3F2l3FAoLZ4yDXikh8IeMUhSCPUtO1NU8uK0jdZQfmL4hjwqSOzGQlFa3UF1WNHbhvp\/wdoUPhrwdpWkQxSRi3t1DrJjd5h+ZycMwBLFjgMQM4BIxQB5\/+0Loc2o+A4tUiupETS7hXlgMhCSLIRHnbjl1YrgkjAZ\/WuI\/Z18ULY+IL7w3cSSbNRQTWoLsVEsYJYBcYBZOS2R\/qgOcjH0fPBDdW8tvcRRzQSoUkjkUMrqRggg8EEcYryfwj8ILmx1S01nXZ9NttUtLgSpLoSPAZQMYV\/uxBCCysqRKSMEty2QD1yiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigDh\/iJ8MtL+INnEZZPsWpwYEN8ke8hM5KMuRuXkkcjB5B5YH5w+I+jawnjZYrhJ764mitrNLqMPKt5cRQRRShHIzIwkBU993BAPFfY9Y9v4W0az1yTWbSz+y303M7W0rxJOfmO6SNSEkbLsdzAnnrwKAPnC8u\/jV4viGjXVtrnkz7gytZCyRxtIKvJtQbSCRtY4PHBOK9T+E3wmh8G26axrCRzeIJU4GQy2akcqp6FyOGYf7o4yW9UooAz9c0az8Q6He6RfpvtbuJonwASuejLkEBgcEHHBANfPHgzwgfBXxtja9vrG2sbO7lhtkmv4ZLmYSgxQDyoyX3MJUY5VQBknFfS9cXcfC7w5e+PH8YXi3dxqBeKRI2m2xRSRhAjqFAJI2Dgkjk8dMAHaV5H8cvCc3ia30SSFNSY27zRg2dgbpVaQJgyhW3qnyHLKj\/TOA3rlFAHB\/B7Q5tB+G9hDNdSXBuHkuUJkLRiN2+QxggFUZQr7SAcu2QCSB0E+hNZ3Et\/oLx2VxI5lntQqrb3rk5JkwpKucn94nOdpYSBQtblZfiXUptG8K6vqlusbT2VlNcRrICVLIhYA4IOMj1FAHzprHijWPFnxmTS30qxWddQSw+WN53gWJsFklTy5FVHEkuUMbHJDEqoA7f4oeG\/GHijydHktYNZWKI3EJ09ZrDy5TuUM5laSCRRx8u4S\/NxtXcTwH7PNjb3fxKkmnj3yWmnyzQHcRscskZPHX5XYc+vrivqegDzvwDHqXgHwRpmk+JbKO3ghRz9rtpGnWIu7SETgJiIKGPz5aP5GJZfl3dZ4rj8zwlq2NNg1ORLSSWKyng85JpEUsilP4vmC8Dn05rYrn\/wDhCtBj4s7WfTo+ph0y8mso2P8AeKQuqlug3EZwAM4AoA8I8NeFfESS2GpazonhzQdAF3Ev2HUNOjee5Xcd8UQkSS4eRgrYVm3HcNnGMe7\/ANp+INQ+bTNGgtrV\/lW41Odo5AD0kECKSVwQdrvG5IIITrVzTfD2maVcNdW8Ej3bIYzdXU8lxPsyDsEkjM4TIztzjOTjJNalAHP\/ANuXGi\/u\/EvkRQDpq8QEVoSeiurOzRN1GSSh+X5wzhBuQTw3VvFcW8sc0EqB45I2DK6kZBBHBBHOakrDn8F+Fbq4luLjw1o008rl5JJLCJmdickklckk85oA3KK5\/wD4QrQY+LO1n06PqYdMvJrKNj\/eKQuqlug3EZwAM4Ao\/wCEN0v\/AJ+tc\/8AB7e\/\/HqAOgori9N1W+074lt4QNzJd6f\/AGOdRjluvmnjbzhEIw4xuQKM5fc5JJLmu0oAKKKKACiiigAooooAKKKKAP\/Z","status":"OK","type":"captcha","validFor":120}}"

    Сделал через замену текста регулярным выражением с
    orderValue.b64
    на
    orderValue_b64
    и потом уже в кубике кубике получить значение
    .result["orderValue_b64"]

    Действие "Получить значение"

    .[("orderValue.b64")]
  • L

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

    Поддержка
    0 Votes
    23 Posts
    2714 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
    1183 Views
    L

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

  • S

    Как правильно отправить json в БАС из google sheets?

    Поддержка
    1 Votes
    7 Posts
    3272 Views
    S

    Ктож знал, что переадресацию надо было включить...

    Тему можно закрывать.