skip to Main Content

Find entry in JSON (Kraken.com uncommon JSON format) – PHP

I need to find if a string exists in JSON Kraken.com retrieved file: I get it this way: $sURL = "https://api.kraken.com/0/public/OHLC?pair=ETHAED&interval=5&since=". strtotime("-1 day"); $ch = curl_init(); $config['useragent'] = 'Mozilla/5.0 (Windows NT 6.2; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0'; curl_setopt($ch, CURLOPT_USERAGENT, $config['useragent']); curl_setopt($ch,…

VIEW QUESTION

Dynamic Menu from multiple JSON files – Jquery

I would like to create a menu from multiple JSON files. Please see the following: https://jsfiddle.net/varJSFiddle/teghqov0/10/ The desired output would be a dynamic menu that looks something like: <ul class="filter-menu-wrapper"> <li class="filter-menu is-active" id="filter-menu_01"><span class="filter-category">Type<i class='cstm-icon-glyph cstm-icon-glyph-plus'></i></span> <div class="filter-options"> <span…

VIEW QUESTION

Postgresql – SQL query to read nested JSON object

How to read JSON object matching query params? I want to filter data for video urls which only contains query params from metadata column and replace it by the removing the query params. metadata {"video-url":"xyz.com/video/xy4jnj?pubtool=oembed","provider":"some-video","video-id":"x8cse6q"} {"video-url":"xyz.com/video/x8cse6q?pubtool=oembed","provider":"some-video","video-id":x8cse6q} {"video-url":"xyz.com/video/x8cse6q","provider":"some-video","video-id":"x8cse6q"} select * from…

VIEW QUESTION
Back To Top
Search