Is there any way to import data from a web API into MySql? [on hold]2019 Community Moderator ElectionShould I use the datetime or timestamp data type in MySQL?How can I get column names from a table in SQL Server?When should I use cross apply over inner join?Understanding REST: Verbs, error codes, and authenticationHow to import CSV file to MySQL tableWhat are the options for storing hierarchical data in a relational database?Posting a File and Associated Data to a RESTful WebService preferably as JSONHow to POST JSON data with Curl from Terminal/Commandline to Test Spring REST?SQL query return data from multiple tablesHow to import an SQL file using the command line in MySQL?
What should I do when a paper is published similar to my PhD thesis without citation?
Is divide-by-zero a security vulnerability?
Mixed Feelings - What am I
Having the player face themselves after the mid-game
Unfamiliar notation in Diabelli's "Duet in D" for piano
Why is there an extra space when I type "ls" on the Desktop?
Giving a career talk in my old university, how prominently should I tell students my salary?
Should I apply for my boss's promotion?
What is Tony Stark injecting into himself in Iron Man 3?
Can I negotiate a patent idea for a raise, under French law?
Insult for someone who "doesn't know anything"
After Brexit, will the EU recognize British passports that are valid for more than ten years?
Why isn't P and P/poly trivially the same?
Can I challenge the interviewer to give me a proper technical feedback?
What would be the most expensive material to an intergalactic society?
PTIJ: Sport in the Torah
What can I do if someone tampers with my SSH public key?
Can the Witch Sight warlock invocation see through the Mirror Image spell?
Too soon for a plot twist?
Boss Telling direct supervisor I snitched
Should I file my taxes? No income, unemployed, but paid 2k in student loan interest
Short SF story. Females use stingers to implant eggs in yearfathers
Why does this boat have a landing pad? (SpaceX's GO Searcher) Any plans for propulsive capsule landings?
How does learning spells work when leveling a multiclass character?
Is there any way to import data from a web API into MySql? [on hold]
2019 Community Moderator ElectionShould I use the datetime or timestamp data type in MySQL?How can I get column names from a table in SQL Server?When should I use cross apply over inner join?Understanding REST: Verbs, error codes, and authenticationHow to import CSV file to MySQL tableWhat are the options for storing hierarchical data in a relational database?Posting a File and Associated Data to a RESTful WebService preferably as JSONHow to POST JSON data with Curl from Terminal/Commandline to Test Spring REST?SQL query return data from multiple tablesHow to import an SQL file using the command line in MySQL?
I have access to a Web Rest API, but would like to access it through a MySql server. It requires an API key, and outputs information in CSV format. Is there a query that can pull that data into a MySql table?
Thank you in advance!
mysql sql rest
asked 2 days ago
Vincent TurnerVincent Turner
162
put on hold as unclear what you're asking by tadman, Barmar, Paul Spiegel, Shadow, Sam Hanley 2 days ago
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
|
show 2 more comments
I have access to a Web Rest API, but would like to access it through a MySql server. It requires an API key, and outputs information in CSV format. Is there a query that can pull that data into a MySql table?
Thank you in advance!
mysql sql rest
asked 2 days ago
Vincent TurnerVincent Turner
162
put on hold as unclear what you're asking by tadman, Barmar, Paul Spiegel, Shadow, Sam Hanley 2 days ago
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
It is wrong design if it exists. You should communicate with an api
– ahmet
2 days ago
Do you mean you want to import the CSV (e.g. on a cron job) so you duplicate the data from your API in your database?
– Neville Kuyt
2 days ago
I don't think you can make a HTTP request directly from within a MySQL script, unless you write it in C and compile it as a user-defined function. But you could write a little program in any other language which fetches the data from the API, and then loads it into MySQL (either line by line with a loop to run INSERT commands, or by downloading the data into a CSV and then using LOAD DATA INFILE to import it to MySQL).
– ADyson
2 days ago
Short answer: Yes. Long answer: Sure. You can't do this with just MYSQL though, you'll need some kind of programming language that uses MySQL for storage.
– tadman
2 days ago
@tadman well, technically you can do this even within mysql, via compiled user defined functions (UDF). There are publicly available UDF libraries that can send http requests and do all sorts of other stuff you do not necessarily want an RDBMS to do. Searching for stuff like "mysqludf rest" or "mysqludf http" (yes, mysqludf is deliberately one word) can give some pointers. Obviously, there is not much out there in terms of how to use these libraries and functions, no one knows their performance, and MySQL's error handling is not designed to handle their errors. But, it is possible.
– Shadow
2 days ago
|
show 2 more comments
I have access to a Web Rest API, but would like to access it through a MySql server. It requires an API key, and outputs information in CSV format. Is there a query that can pull that data into a MySql table?
Thank you in advance!
mysql sql rest
asked 2 days ago
Vincent TurnerVincent Turner
162
I have access to a Web Rest API, but would like to access it through a MySql server. It requires an API key, and outputs information in CSV format. Is there a query that can pull that data into a MySql table?
Thank you in advance!
mysql sql rest
mysql sql rest
asked 2 days ago
Vincent TurnerVincent Turner
162
asked 2 days ago
Vincent TurnerVincent Turner
162
asked 2 days ago
Vincent TurnerVincent Turner
162
asked 2 days ago
Vincent TurnerVincent Turner
162
asked 2 days ago
Vincent TurnerVincent Turner
162
162
put on hold as unclear what you're asking by tadman, Barmar, Paul Spiegel, Shadow, Sam Hanley 2 days ago
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
put on hold as unclear what you're asking by tadman, Barmar, Paul Spiegel, Shadow, Sam Hanley 2 days ago
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
It is wrong design if it exists. You should communicate with an api
– ahmet
2 days ago
Do you mean you want to import the CSV (e.g. on a cron job) so you duplicate the data from your API in your database?
– Neville Kuyt
2 days ago
I don't think you can make a HTTP request directly from within a MySQL script, unless you write it in C and compile it as a user-defined function. But you could write a little program in any other language which fetches the data from the API, and then loads it into MySQL (either line by line with a loop to run INSERT commands, or by downloading the data into a CSV and then using LOAD DATA INFILE to import it to MySQL).
– ADyson
2 days ago
Short answer: Yes. Long answer: Sure. You can't do this with just MYSQL though, you'll need some kind of programming language that uses MySQL for storage.
– tadman
2 days ago
@tadman well, technically you can do this even within mysql, via compiled user defined functions (UDF). There are publicly available UDF libraries that can send http requests and do all sorts of other stuff you do not necessarily want an RDBMS to do. Searching for stuff like "mysqludf rest" or "mysqludf http" (yes, mysqludf is deliberately one word) can give some pointers. Obviously, there is not much out there in terms of how to use these libraries and functions, no one knows their performance, and MySQL's error handling is not designed to handle their errors. But, it is possible.
– Shadow
2 days ago
|
show 2 more comments
It is wrong design if it exists. You should communicate with an api
– ahmet
2 days ago
Do you mean you want to import the CSV (e.g. on a cron job) so you duplicate the data from your API in your database?
– Neville Kuyt
2 days ago
I don't think you can make a HTTP request directly from within a MySQL script, unless you write it in C and compile it as a user-defined function. But you could write a little program in any other language which fetches the data from the API, and then loads it into MySQL (either line by line with a loop to run INSERT commands, or by downloading the data into a CSV and then using LOAD DATA INFILE to import it to MySQL).
– ADyson
2 days ago
Short answer: Yes. Long answer: Sure. You can't do this with just MYSQL though, you'll need some kind of programming language that uses MySQL for storage.
– tadman
2 days ago
@tadman well, technically you can do this even within mysql, via compiled user defined functions (UDF). There are publicly available UDF libraries that can send http requests and do all sorts of other stuff you do not necessarily want an RDBMS to do. Searching for stuff like "mysqludf rest" or "mysqludf http" (yes, mysqludf is deliberately one word) can give some pointers. Obviously, there is not much out there in terms of how to use these libraries and functions, no one knows their performance, and MySQL's error handling is not designed to handle their errors. But, it is possible.
– Shadow
2 days ago
It is wrong design if it exists. You should communicate with an api
– ahmet
2 days ago
It is wrong design if it exists. You should communicate with an api
– ahmet
2 days ago
Do you mean you want to import the CSV (e.g. on a cron job) so you duplicate the data from your API in your database?
– Neville Kuyt
2 days ago
Do you mean you want to import the CSV (e.g. on a cron job) so you duplicate the data from your API in your database?
– Neville Kuyt
2 days ago
I don't think you can make a HTTP request directly from within a MySQL script, unless you write it in C and compile it as a user-defined function. But you could write a little program in any other language which fetches the data from the API, and then loads it into MySQL (either line by line with a loop to run INSERT commands, or by downloading the data into a CSV and then using LOAD DATA INFILE to import it to MySQL).
– ADyson
2 days ago
I don't think you can make a HTTP request directly from within a MySQL script, unless you write it in C and compile it as a user-defined function. But you could write a little program in any other language which fetches the data from the API, and then loads it into MySQL (either line by line with a loop to run INSERT commands, or by downloading the data into a CSV and then using LOAD DATA INFILE to import it to MySQL).
– ADyson
2 days ago
Short answer: Yes. Long answer: Sure. You can't do this with just MYSQL though, you'll need some kind of programming language that uses MySQL for storage.
– tadman
2 days ago
Short answer: Yes. Long answer: Sure. You can't do this with just MYSQL though, you'll need some kind of programming language that uses MySQL for storage.
– tadman
2 days ago
@tadman well, technically you can do this even within mysql, via compiled user defined functions (UDF). There are publicly available UDF libraries that can send http requests and do all sorts of other stuff you do not necessarily want an RDBMS to do. Searching for stuff like "mysqludf rest" or "mysqludf http" (yes, mysqludf is deliberately one word) can give some pointers. Obviously, there is not much out there in terms of how to use these libraries and functions, no one knows their performance, and MySQL's error handling is not designed to handle their errors. But, it is possible.
– Shadow
2 days ago
@tadman well, technically you can do this even within mysql, via compiled user defined functions (UDF). There are publicly available UDF libraries that can send http requests and do all sorts of other stuff you do not necessarily want an RDBMS to do. Searching for stuff like "mysqludf rest" or "mysqludf http" (yes, mysqludf is deliberately one word) can give some pointers. Obviously, there is not much out there in terms of how to use these libraries and functions, no one knows their performance, and MySQL's error handling is not designed to handle their errors. But, it is possible.
– Shadow
2 days ago
|
show 2 more comments
0
active
oldest
votes
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
It is wrong design if it exists. You should communicate with an api
– ahmet
2 days ago
Do you mean you want to import the CSV (e.g. on a cron job) so you duplicate the data from your API in your database?
– Neville Kuyt
2 days ago
I don't think you can make a HTTP request directly from within a MySQL script, unless you write it in C and compile it as a user-defined function. But you could write a little program in any other language which fetches the data from the API, and then loads it into MySQL (either line by line with a loop to run INSERT commands, or by downloading the data into a CSV and then using LOAD DATA INFILE to import it to MySQL).
– ADyson
2 days ago
Short answer: Yes. Long answer: Sure. You can't do this with just MYSQL though, you'll need some kind of programming language that uses MySQL for storage.
– tadman
2 days ago
@tadman well, technically you can do this even within mysql, via compiled user defined functions (UDF). There are publicly available UDF libraries that can send http requests and do all sorts of other stuff you do not necessarily want an RDBMS to do. Searching for stuff like "mysqludf rest" or "mysqludf http" (yes, mysqludf is deliberately one word) can give some pointers. Obviously, there is not much out there in terms of how to use these libraries and functions, no one knows their performance, and MySQL's error handling is not designed to handle their errors. But, it is possible.
– Shadow
2 days ago