Unfortunately something like that is not possible out of the box. You'll need to create some PHP script that will create PHP serialized array from these JSON files.
You can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features.
After reviewing the sandbox I see you can link to google docs, I think this will be an option for what I would like to achieve. How does this affect the site, ie; is it slower to do like link through google docs to wpdatatables than custom PHP script, right?
It is pretty same when you have small amount of data. It is recommended that if you have more than 1000 rows use wpDataTables with server-side processing option enabled. It is possible to create Manual table type from Google Spreadsheet file where you can enable this option. Please read more about server-side processing tables on this page from out documentation.
I have created a table in Google Sheets with approx. 200 + rows with 6 columns pulling the information I have set. Google docs has a limit of how many times information can be pulled from the API. (I also noticed the table was taking more than 2 minutes to load).
Do you suggest I purchase the wpdatatables plugin to set up server-side processing tables?
If table is slow then we suggest to use server-side processing feature. Can you please send me a data that you want to use in wpDataTables (Google spreadsheet file) so I can take a look if it is possible to create wpDataTable from it.
Okay sure, here is the Google spreadsheet link , Click here ( I used code.gs to pull data from the api)
This may work on your end, but I am receiving an error message "Service invoked too many times for one day: urlfetch."
So I purchased a copy of wpDatatables and created a JSON wpDatatable using the www.coinmarketcap.com/api and listed all the coins with no problems at all. But as I mentioned previously I want to only list approx 200 selected coins.
Hi there,
Would like to enter multiple json links into one datatable.
If you refer to the API here https://coinmarketcap.com/api/ you have them pull the information separately like this-
https://api.coinmarketcap.com/v1/ticker/bitcoin/
https://api.coinmarketcap.com/v1/ticker/etherem/
https://api.coinmarketcap.com/v1/ticker/siacoin/
https://api.coinmarketcap.com/v1/ticker/reddcoin/
thank you for your help in advance.
Hi Craig,
Thank you for the inquiry.
Unfortunately something like that is not possible out of the box. You'll need to create some PHP script that will create PHP serialized array from these JSON files.
You can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features.
Hi Milos,
Thank you for your prompt response.
After reviewing the sandbox I see you can link to google docs, I think this will be an option for what I would like to achieve. How does this affect the site, ie; is it slower to do like link through google docs to wpdatatables than custom PHP script, right?
Hi Craig,
It is pretty same when you have small amount of data. It is recommended that if you have more than 1000 rows use wpDataTables with server-side processing option enabled. It is possible to create Manual table type from Google Spreadsheet file where you can enable this option. Please read more about server-side processing tables on this page from out documentation.
Hi Milos,
I have created a table in Google Sheets with approx. 200 + rows with 6 columns pulling the information I have set. Google docs has a limit of how many times information can be pulled from the API. (I also noticed the table was taking more than 2 minutes to load).
Do you suggest I purchase the wpdatatables plugin to set up server-side processing tables?
Hi Craig,
If table is slow then we suggest to use server-side processing feature. Can you please send me a data that you want to use in wpDataTables (Google spreadsheet file) so I can take a look if it is possible to create wpDataTable from it.
Hi there,
Okay sure, here is the Google spreadsheet link , Click here ( I used code.gs to pull data from the api)
This may work on your end, but I am receiving an error message "Service invoked too many times for one day: urlfetch."
So I purchased a copy of wpDatatables and created a JSON wpDatatable using the www.coinmarketcap.com/api and listed all the coins with no problems at all. But as I mentioned previously I want to only list approx 200 selected coins.
Thank you for your help.
Hi Craig,
If you have purchased wpDataTables, please open a ticket in wpDataTables category and one of our support agents will provide you help with this.
Hi, Okay sure will do now thanks for your help.