Web Analytics Made Easy -
StatCounter

API / web service

I have 15+ years experience in researching automobile industry and compile data in Excel… and I am looking for a skilled web developer with high interest in cars, that can help me to provide API beside selling Excel / CSV / SQL files. I give FREE API access to whoever help me!

My lack of experience in programming prevent me from hiring a random developer from sites like Upwork because they require me to explain project requirements that I don’t know. If you are not willing to help me making API but you are interested to subscribe to my future API, please tell exactly what do you require from API so I can tell to developer once I find one.

First, I want to have full management of API, it need to be hosted either on same VPS who host my website, either on an AWS account registered under my name. Please don’t say “I will host and manage API myself and pay you % of revenues I do” (since I wrote this page in 2016, some people made me such proposals that violate my Terms of Service).

Actually, the idea to make an API came in 2014… once I found other websites offering such service (example: CarListDB.com – a website that ran between 2011 and 2015, storing themselves database for other websites to query data from, for $99 for first year and $30 for following years (instead of selling Excel, CSV or SQL files). The data they had was similar with my Year-Make-Model, no detailed specs.

Such API is good for certain customers who like to have database updated on their websites automatically without needing to re-download Excel files from me and import in phpMyAdmin after each time I update database. But this won’t replace the sale of Excel databases which is preferred method by at least half of customers.

In 2015 I contacted some PHP developers, asking if is possible to make a plugin for WordPress that takes subscription, they said that can make a plugin, but they charged higher than what I earned in 1 month. Moreover I didn’t know how to explain clearly what I need from plugin and most likely I would not have been satisfied and I had to pay extra money to improve the plugin to make it usable for my multiple databases sold in a variety of options.

I rather ask my own customers buying vehicle databases, who make API for their own business use, to give me the API scripts and WordPress plugin to put them on my server and provide API to other customers too, in exchange of FREE access to data, forever! Someone who can modify the scrips until runs perfectly for himself, without extra charges.

There are few websites offering such API web service, but they offer a single database. Personally I offer a variety of databases for multiple continents, and sometimes I do additional changes for individual customers, this makes very complex to implement an API.

The big European database is for sale in 16 different packages (4 options for number of columns: Car Models & Engines, Car Models & Engines & Tires, Car Models & Engines & Dimensions, Car Models & Engines & All details, multiplied by 4 historical coverage options: 1970s-present, 1990s-present, 2000s-present, new cars only. The American database also come in 6 standard packages: Trims only, Basic specs, Full specs, and 1990-present vs new cars only (last 3 years only), and occasionally customers ask me to sell them custom packages like 2005-present, SUVs & trucks only, etc). I wonder if would be possible to store the data in a single MySQL database and give customers access to specific rows and columns depending by how much they pay, instead of making 16 MySQL databases for Europe and 6 for America.

Importing Excel in MySQL is just the easy part. The complex part is developing a subscription system that give you a key to access API and disable the key when subscription ends, unless you renew it.

Someone suggested that API should have various packages limited in number of queries. This gave me idea for a pricing formula: pay $100 to get 10,000 queries, pay $200 to get 100,000 queries, pay $400 to get 1,000,000 queries (each 2x increase in price give you 10x increase in queries, actual prices and query limits are subject to change, depending by demand. But this means that European database would need 16 x 3 = 48 API price packages?

Another idea to not offer packages with access to partial years of data and just charge per query without fixed monthly/yearly contracts (I want ability to set price per query individually for each customer, in case someone want a large number of queries to negotiate lower price), but I am not sure how this system would work, will customers be charged automatically at end of month based on how many queries they have done? What if their bank account runs empty? What if some bad minded guy query ONCE each of 20,000 cars in European car database and build his own Excel database, then cancel subscription, thus obtaining whole database cheaper than the price I am selling my own Excel file?

In January 2016 one customer told me that I can create API for FREE using www.kimonolabs.com. I am confused about how to use this website, and don’t know how to link the API with a subscription system on my website (probably I need to import my data in Kimono and give manually the access codes to people paying on my website, and remove the access when their payment ends unless they pay more)

He said that is busy and will come back later to help me using KimonoLabs, until he came back the KimonoLabs was closed (as March 2016 it say “Kimono shut down on February 29th, 2016 and the cloud service has been discontinued. Your APIs can still be accessed via Kimono for Desktop. Download the application and import your APIs before March 31, 2016.

Does anyone else know an alternative to KimonoLabs and have time to teach me how to create API?

Page published in March 2016

News about API

Nexus Web Development, who left comment on this page, offered to build an API for free to host at my server in exchange of data + advertising their services, he did a small JSON prototype but at that moment I had no idea what use it will have, and this gave him impression that I am not motivated for API and he don’t want to work with me anymore.

My Pakistani friend who is doing web scraping told me to use inspect element > Network tab when I select something from drop-down boxes on various websites, by this way I figured out that they source data from a JSON code similar with the one done by Nexus.

So this is the actual API! But what was expecting was a graphical interface that takes payment and give access to API.

Over next months been contacted by several more people offering me to build API but after some talk I realized that what they actually wanted is to create their own API using my data but hosting on their server and give me 50% of revenues. Someone saying “I contacted you because I saw a business opportunity, I can provide a service that you don’t have and you are looking for”. But this create a competitor service and violate my Terms of Service. I cannot control what will be his earnings from my API, but most likely earnings will be small because a simple website made just for API will hardly get popular in Google, or if he is a SEO expert, website will get so popular and steal customers from me.

Due to this reason, year 2016 ended without me having API.

After few attempts to convince other people to build API in exchange of free access to data, I realized that I have no success this way… and went to my Pakistan programmer which I paid him about 10 times since 2015 for various web scraping jobs. He is skilled in PHP, as well as C# and VB.NET, but not in WordPress.

The problem is that he know nothing about automobile industry, so I need to explain him very specific the requirements for my API, and I personally don’t know what my customers would expect from API, so could not gave him enough info to start building API service.

In July 2017 I emailed 10 existing customers asking for requirements but the lazy people did not replied me.

In August 2017, for the first time, an indian told me his requirements for an API. But I choose to make API first for American database Year-Make-Model-Trim-Specs because it have higher sale volume, it is similar with Edmunds website which also provide API, so my programmer will have an API model to to follow.

As far I understand how API will be working:

  • API will provide the makes, the models of each make, the years of each model, the trims of each model year, and the full specs of a model. If you need additional endpoints please ask!
  • I am questioning if is possible to limit API to trims only, basic specs, full specs, and 2016-2018 instead of 1990-2018, similar with Excel packages.
  • You will also have option to buy 1000 queries per month, 10000, 100000, etc, and upgrade once your business grow up (this really put me in trouble how to price packages because if highest API package is priced higher than Excel download, people will choose Excel download, and if API is cheaper people will choose API and make my income to drop, maybe I should increase price of Excel files?)
  • You get an API key valid for 1 year which you can renew at 50% per year. In first stage I will add API keys manually for people purchasing Excel files, but in the future I need also a register/login system where you can pay yourself and upgrade/renew keys which I am questioning if can use WordPress one or need a separate system.
  • Because my VPS do not have perfect stability and may not handle scaling in the future, I would like API to be hosted on Amazon Web Services https://aws.amazon.com/api-gateway/pricing/, now the big question is how to link my WordPress website to AWS API, where to store keys, etc. Normally I store each car database in one table in phpMyAdmin and importing it after every update. As far I know, AWS don’t use cPanel, will it have phpMyAdmin or how do I upload database after each update?
  • I need a way to integrate API purchasing and management with my WordPress website and charge payments for subscription. I suggested him to make a WordPress plugin, where to have options to configure prices and columns for each key, but he suggested a separate platform with Laravel framework. I have no idea how this will be working. But I don’t want the API to be in separate page than page where I am selling Excel databases. Forget the Laravel, he had done a piece of SHIT with it.
  • I prefer a WordPress plugin  similar with Easy Digital Downloads and WooCommerce, its management panel need to have tabs like APIs (with configuration of packages, initial pricing, renewal pricing, columns of access and number of queries, and able to display API packages anywhere on website with shortcodes), Customers (list of people, showing what API they purchased, keys, date of purchase/expiry and number of queries done), Stats (number of people purchasing per day and month), and Settings (where I can configure PayPal email, 2checkout integration, etc).
  • Shortcodes will display list of plans/packages similar with Easy Digital Downloads one https://www.teoalida.com/cardatabase/year-make-model-trim-specs/, with radio buttons (not side by side to allow any number of packages)
  • After selecting API package you want, you get redirected to a checkout page similar with Easy Digital Downloads having option to register an account or to login, then you can select PayPal or 2checkout. I am questioning if is better to use WordPress user panel or to make own login system dedicated to API plugin.

Any additional suggestions are welcome!

A bunch of incompetent programmers

I showed the API made by Pakistan programmer to several people and they said that is not good and not efficient. While this guy is experienced in web scraping, is not really experienced in PHP and APIs. Maybe I should look for other developers…

In November an american we chatted 3 hours about this and he showed me a quick demo. Few days later I emailed him and he said that is just about to have API finished and will give me by Monday, but no reply from him Monday, I emailed him again Wednesday and 2 times again next week, never heard from him anymore.

In January 2018 another group of Romanians with low budget interested in my car database, offered me to make API for free in exchange of free data, we added in Google Hangouts, but he never signed in again since that day.

Beside them, had also a couple of idiots trying to abuse my data, “seeing a business opportunity” they offered to make an API that will host and manage themselves and pay me a percentage of their revenues. This is violating my Terms of Service because it may steal customers from me. Sorry, but can’t trust that they will pay me the right share.

Bad experience with an indian developer

Last week of February been dealing with an indian developer who previously bought Indian car and bike databases in June 2017 when he purchased a database, since that day he suggested making API as a separate platform in Laravel rather than WordPress. He said that is going to make API for all my databases including Indian ones for $750 in total, and we can start with one database for $250. Paid him 25% in advance and 75% when he finished the job before giving me the script files…

But this turned to be a major disappointment. We both WASTED 7 hours in TeamViewer trying to install his scripts on my server, had problems with PHP version, he blamed my hosting provider that is not optimized for modern software like Laravel, had to ask my hosting to install PHP 7.1 because at the time I bought VPS it was up to PHP 5.6, then when logging in my account his script was displaying a page with errors so he had to fix it, we WASTED another hour trying to integrate my PayPal account into this, I don’t understand why he went to a very complex way to create a PayPal sandbox account instead of using the simple way used by Easy Digital Downloads, etc.

A fucking idiot! 32-year old man with 7 years experience in webdesign, can’t believe how unexperienced he is since he had to waste 7 hours to do such simple things.

Website design contains several mistakes too, for example when clicking Get started it goes to Login page instead of Register (how to login if you don’t have an account?), and despite that I told him to make Demo at top of page, then Pricing packages, then a text box where to write FAQ and last updates changelog for SEO, he made Demo on a subpage, which don’t know how will work if we make multiple APIs. Well, these things can be corrected, but the worst thing… this FUCKING LARAVEL don’t have any CMS to add additional pages or text on page, which I wanted to add an about me, changelog which needs to be edited each update, FAQ, etc, if I want to change something I need to edit PHP files which is risky because a letter wrong makes website undisplayable!

API would have been ready to use if I find a way to import a 150 MB CSV file into phpMyAdmin which keeps failing due to file size, and to configure proper subscription prices. BUT his API omit Year, it have Make, Model, Trim, typical for indian cars but in case of American cars the model year is a MUST, making it effectively unusable.

He wants another $100 to make an importer in admin panel, another $250 to add a CMS to his Laravel, etc, but I don’t want to give any more money to this idiot! This is how some Indians SCAM us, ask small initial price and to bad quality job then ask extra money, probably I was ending paying him $2000+ and still NOT HAPPY. Let’s forget the idiot Indian!

American SNAIL developers

Emailing 4 customers showing them the above bad experience with the indian, made 2 of them to offer me making a proper API free of charge. Well, not completely free but in exchange to free access to data.

They told me that subscription interface for API is not necessary (and also not recommended) to be hosted on same place, and API require stability and 100% uptime which my VPS can’t offer. Larry suggested hosting API on Amazon Web Services while Sunny has made a WordPress plugin extension to Easy Digital Downloads to create API plans and link to AWS.

By May 2018 Sunny finished his WordPress plugin and was waiting for Larry to finish AWS setup, he said that is nearly finished… then got a baby. We started to not hear from him, API development continued with 1 step per 2 weeks. 3 months passed for no reason. In August Larry told me to buy AWS account in my name so he can setup API on my server. He did not had time to setup until October, when we had the Skype conversation seen below.

I don’t know what is next step or how many steps are yet to go I can allow my customers to subscribe to API. Even Sunny was angry because he has to have API access for free according bartering agreement, wasted his time developing plugin, but did not got a functional API.

Meantime I got a huge $1000+ bill without having any functional API. I don’t know what the fuck done Larry, but now I risk suspension of Amazon Web Services account.

Anyone else experienced in AWS please help me!

I give FREE API access to people who has purchased Excel databases in the past, and after at least 3 people confirm that API is properly working I will start API subscription service separate than Excel sales.

APIAPI Skype

19 comments

1 ping

Skip to comment form

  1. I am a professional programmer, and I would be interested in discussing an API with you. Here is my suggestion…

    Give me a small (redacted) data set to test with. You can send it in any format you want, so long as it is representative of your existing datasets. I will build an API for the test data set and put it online in my test server, and I will send you a link and the documentation to access the test data set.

    If you’re interested, just email me back. I don’t use online chat, but I see my email regularly.

    1. You can use any of the Excel / CSV / SQL samples to test it… but how about subscription service?

  2. We would be able to create an API for your data sets.The data format returned could be in JSON, XML, CSV or HTML.

    1. This page is less than 2 weeks old and you’re 2nd person who offer me to create an API… also 2nd person who is not telling me what database are you interested. Are you actually interested in my databases or you just want to help me with API and get paid for this?

  3. I am genuinely interested in helping you test an existing API you have, or in helping (for free, no strings attached) you to develop / finish any API work, to your satisfaction.

    If you wanted to give me free access to the API after the fact, that’d be awesome. But I’m not in it for the money or access (even though my company is already paying you for the data via spreadsheet), I just think it would be great if there was an API for your data.

    Contact me via email if interested.

    This is legit, I swear.

    1. Which of my car databases are you interested in?

      • tracy on February 24, 2018 at 1:59 am
      • Reply

      Luke I’d like to talk with you about an api for this db…thanks

    • Ezra Johnson on February 7, 2018 at 2:29 pm
    • Reply

    Is this API has been developed?

    1. Not yet, because I was dealing with a couple of idiot and incompetent developers. Some offering me to make API for free in exchange of free access to data, but running away without completing the deal.

        • Matias on July 5, 2019 at 5:54 pm
        • Reply

        Hi Man, i can help you developing the APIs, if you want some security you can send me just one row of each tipe of data you have as an example and de DB model, y can develop your API in my local environment and then you can install it in your server to expose it to the world.

    • BlackXero on March 19, 2018 at 10:07 am
    • Reply

    First of all you’re doing a great job. This is not the correct place to talk about your API. It should be by email or any private means. Second I can create you a subscription based API, where you can put your conditions like 1 API call charges per customer. And you can put (change,edit,update) your price. and all the required things that you want to make through it. If you’re interested Please don’t reply here. Youcan email me. You can find my email in this message in your wordpress admin panel.

    1. Hello!
      we can develop database API service.
      We develop websites for the sale of auto parts and not only.

      1. The 2 american developers claim that finished job, I am just waiting for instructions how to use API, how to upload database each update, how to configure prices and column/rows of access in each package, etc. Buy they didn’t replied anymore for few days. Even if they fail, I have 1 more person who made a sample API for me and I work with him. But I would like to hear YOUR solutions for my API. Can you message me on LIVE CHAT in lower-left corner of screen to discuss project in details?

    • JC on June 25, 2019 at 1:03 am
    • Reply

    I didn’t read the whole page, I read the last few answers, but I don’t think it makes it clear if you still need someone to help you with your API, if you still need help, let me know, we are actually working on a solution for the automotive parts industry and are looking for an API, which would benefit us mutually.

    1. You don’t need to read whole page, the 1st row say “I am looking for a skilled web developer with high interest in cars, that can help me to provide API beside selling Excel / CSV / SQL files” what is not clear here?

      Last month been very busy with a couple of personal problems unrelated with business. Beside you, other 2 people contacted me via chat and email. I need to have a long conversation with you and them and decide which is best option.

    • RealDev on July 30, 2019 at 9:36 pm
    • Reply

    Maybe if you want skilled professionals you should pay them at professional rates.
    Who the hell is gonna build a reliable API with subscription for peanuts ? (raw data) ? Seriously ?
    It’s a f*cking easy job but still a$10k job, at least.

  4. This does interest me

    • salah eddine on August 16, 2019 at 8:52 am
    • Reply

    Hello,
    i can surely help you with 2 lines of codes for the customer API

    and a function inside your PHP Mysql source code

    you can verify it before adding it

    i will add also the possibility of reading the licence before getting the data, and so the data become accessible from any where and updated automatically like google APIs or Facebook APIs

    in return i want the free access and if you like my work i would like you to add an extra 250$

    Good Luck

    • salah eddine on August 16, 2019 at 8:55 am
    • Reply

    the work will be done in a month

    i can do it in 7 days for 300$

  1. […] I do not have sufficient experience to create API. But YOU can help! Read more. […]

Leave a Reply

Your email address will not be published.