Modify API results on the fly. Modifly
Modifly is a web service designed to augment the results of an API call on the fly.
There are a lot of datasets available online that are useful in all sorts of ways, but all too often the formats or methods used to make the data available are less than ideal.
This simple web service is aimed at giving you a way to get the results you were hoping for from your data source, without really having to do the extra work.
There are a lot of datasets available online that are useful in all sorts of ways, but all too often the formats or methods used to make the data available are less than ideal.
This simple web service is aimed at giving you a way to get the results you were hoping for from your data source, without really having to do the extra work.
CSVModify
Base URL:
http://api.modifly.co/
Operation:
csvmod
Parameters:
url=
URL of the CSV file to convert to JSON.
Must be URLEncoded. Here's a helpful tool for that. http://meyerweb.com/eric/tools/dencoder/
headers=
Strings separated by commas.
Allows you to decide what headers to use for each column, rather than taking the first row.
This is intended for when you don't have a header row in your CSV.
key=
A key for your account. Without providing a key, the service will only return the first 50 records of your dataset.
Get a key here.
format=json/xml
Indicate what format you want to receive the data in. Currently, only JSON is supported.
offset=
Offset from the beginning of the first record before starting to return values.
Requires 'key' to be valid.
limit=
Limits the number of records returned to a specific amount.
Requires 'key' to be valid.
hfr=true/false
Absolutely determines whether the target CSV file should be treated as if it has a header first row.
http://api.modifly.co/
Operation:
csvmod
Parameters:
url=
URL of the CSV file to convert to JSON.
Must be URLEncoded. Here's a helpful tool for that. http://meyerweb.com/eric/tools/dencoder/
headers=
Strings separated by commas.
Allows you to decide what headers to use for each column, rather than taking the first row.
This is intended for when you don't have a header row in your CSV.
key=
A key for your account. Without providing a key, the service will only return the first 50 records of your dataset.
Get a key here.
format=json/xml
Indicate what format you want to receive the data in. Currently, only JSON is supported.
offset=
Offset from the beginning of the first record before starting to return values.
Requires 'key' to be valid.
limit=
Limits the number of records returned to a specific amount.
Requires 'key' to be valid.
hfr=true/false
Absolutely determines whether the target CSV file should be treated as if it has a header first row.
URL Maker
Example
Yahoo Finance Historical Stock Prices CSV API
The call below downloads the historical stock prices for the ticker symbol 'GOOG'.
http://ichart.finance.yahoo.com/table.csv?s=GOOG&a=10&b=15&c=2012&d=09&e=22&f=2013&g=d&ignore=.csv
URLEncoded, that URL looks like this:
http%3A%2F%2Fichart.finance.yahoo.com%2Ftable.csv%3Fs%3DGOOG%26a%3D10%26b%3D15%26c%3D2012%26d%3D09%26e%3D22%26f%3D2013%26g%3Dd%26ignore%3D.csv
And then with our CSV to JSON call, it looks like this:
http://api.modifly.co/csvmod?url=http%3A%2F%2Fichart.finance.yahoo.com%2Ftable.csv%3Fs%3DGOOG%26a%3D10%26b%3D15%26c%3D2012%26d%3D09%26e%3D22%26f%3D2013%26g%3Dd%26ignore%3D.csv&format=json
The call below downloads the historical stock prices for the ticker symbol 'GOOG'.
http://ichart.finance.yahoo.com/table.csv?s=GOOG&a=10&b=15&c=2012&d=09&e=22&f=2013&g=d&ignore=.csv
URLEncoded, that URL looks like this:
http%3A%2F%2Fichart.finance.yahoo.com%2Ftable.csv%3Fs%3DGOOG%26a%3D10%26b%3D15%26c%3D2012%26d%3D09%26e%3D22%26f%3D2013%26g%3Dd%26ignore%3D.csv
And then with our CSV to JSON call, it looks like this:
http://api.modifly.co/csvmod?url=http%3A%2F%2Fichart.finance.yahoo.com%2Ftable.csv%3Fs%3DGOOG%26a%3D10%26b%3D15%26c%3D2012%26d%3D09%26e%3D22%26f%3D2013%26g%3Dd%26ignore%3D.csv&format=json