Need help with JSON pls!

#1

Hi all

Would like to ask for help with JSON based table creation.

Generally I would like to run a webpage which will display actual price + price movements of selected cryptocurrencies.
Website is Wordpress based with using wp_datatables plugin (json input needed)

This is how it looks now:
(https://imgur.com/BJsf0EK)

Need to integrate API to my JSON file.

I Don´t know how to make a cell ("price section) variable (for example live data from API)

For example This is actual Bitcoin “price” = https://api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=usd

(to get actual price for Ethereum just change : ids=ethreum)
(to get actual price for Litecoin just change : ids=litecoin)

Here is my JSON file:

[
{
"Name": "Bitcoin",
"Ticker": "BTC",
"Price": "XXX"
},
{
"Name": "Ethereum",
"Ticker": "ETH",
"Price": "XXX"
},
{
"Name": "Litecoin",
"Ticker": "LTC",
"Price": "XXX"
}
]

I would very much appreciate if someone can explain to me how this is done, and/or please send me a link to where I could get a fundamental understanding of what seems like a very important concept.

Thanks a lot.

#2

I’ve edited your post for readability. When you enter a code block into a forum post, please precede it with a separate line of three backticks and follow it with a separate line of three backticks to make it easier to read.

See this post to find the backtick on your keyboard. The “preformatted text” tool in the editor (</>) will also add backticks around text.

Note: Backticks are not single quotes.

markdown_Forums

#3

Hi
https://www.quora.com/Which-APIs-can-provide-real-time-and-historical-crypto-currency-market-data

#4

Hi! I am learning Python basics from youtube and I’m just curious about What Json is, how a Json file is created and how can I use it in basic python projects(like an interactive dictionary). Please help me out or direct me to some helpful documentation or something. _/_

#5
#6