AnsweredAssumed Answered

How to import data from an API link to MAPR DB  and also post MAPR DB data as an API?

Question asked by PraveenKumar on Jun 6, 2018
Latest reply on Jun 7, 2018 by PraveenKumar

My requirement is like to get data from API like "https://www.quandl.com/api/v3/datasets/OPEC/ORB.json " which is in json format and load to it to MAPR DB, using CURL get code i am able to get the data from link and view it over putty but when using curl post code i am getting "server certificate verification failed. CAfile: /etc/ssl/certs/ca-certificates.crt CRLfile: none" error , need to know whether 'curl post' is the right way to achieve my requirement or is there any other way to load it to maprdb?

 

curl get code : curl -X GET  'https://www.quandl.com/api/v3/datasets/OPEC/ORB.json' -u root:mapr

 

curl post code ; curl -X POST 'https:/happy/mapr/my.cluster.com/ApiTest' -u root:mapr -H 'Content-Type: application/json' -d 'https://www.quandl.com/api/v3/datasets/OPEC/ORB.json' -insecure -v

Outcomes