Youtube
japanese & american car AUCTIONS, japanese ONEPRICES, YAHOO.co.jp, BIKES & MACHINERY from Japan, TRUE REPORT & REPORT+ for 16 years
API SQL2XML or DUMP&140 japanese Auctions&Statistics 3 months&True Report 16 years& Sold Prices real-time& FOB,TAX calculators&Cars catalogue&30 min updates
Dealer panel BIDS mangining, groups for BIDS, export TO EXCEL, HISTORY statistics sales, SUBSCRIPTION to cars, own STOCK, saved SEARCH, real-time USER activity, any CURRENCY, 13 LANGUAGES, user CONTROL, CHAT
Month of production True Report 16 years Translation sheet
SQL2XML  SQL2JSON    with pagination v3.0 PORTAL API
Send SQL, get XML or JSON use AND AUCTION_TYPE!=2;   instead AUCTION like 'USS%'
Table names main & stats click and press CTRL+U to see table structure
http://78.46.90.228/api/?code=PASS&sql=select%20*%20from%20main%20limit%2010
http://78.46.90.228/gzip/?code=PASS&sql=select%20*%20from%20main%20limit%2010   <= fast
http://78.46.90.228/api/?json&code=PASS&sql=select%20*%20from%20stats%20limit%2010
http://78.46.90.228/gzip/?json&code=PASS&sql=select%20*%20from%20stats%20limit%2010   <= fast
where id='Jfj4Hhfk8Te'&history   <= history for Korea
where id='Jfj4Hhfk8Te'&inspection   <= inspection for Korea
Images have 3 sizes
1. add &h=50 in end of URL see here
2. add &w=320 in end of URL  use MEDIUM SIZE as much as possible see here
3. original BIG photo  after MANUAL click of user. but "auction sheet" show BIG, this ok see here

1) How get all IMAGES and fields: SERIAL, INFO
select * from stats where id='ZmsWmOlaUXlc3R'   <= ID is important

2) How get CLEAR images  Request here
http://78.46.90.228/api/?code=DvemR43s&sql=select+*+from+main+where+id='ZmsWmOlaUXlc3R'&user_id=123
change =123 to real user_id from your local database

3) How get TAA extra-images  admin Control Panel / IMAGES-TAA / Balance
http://78.46.90.228/api/?code=DvemR43s&sql=select+*+from+main+where+id='ZmsWmOlaUXlc3R'&paid=taa

4) How to send LIKE % or hieroglyphs?
right: select * from main where model_name LIKE '%25accord%25'
select * from main where color='%26%2365404;%26%2365411;%26%2365394;'
incorrectly: select * from main where model_name LIKE '%accord%'
select * from main where color='&#65404;&#65411;&#65394;'

5) FOB-calculator like on site
Control Panel / Calculator Editor. Add calculator, then click: API
CSV for Drop-Down menu
Download &
cache it
Count Vendors Models Chassis
AUCTIONS each 30 minutes lots manuf model body
STATISTICS each 24 hours lots_st manuf_st model_st body_st
AUCTIONS big img each 30 minutes LOTS MANUF MODEL BODY
STATISTICS big img each 24 hours LOTS_ST MANUF_ST MODEL_ST BODY_ST
ONEPRICE each 6 hours lots_one manuf_one model_one body_one
KOREA each 12 hours lots_kr manuf_kr model_kr
CHINA each 12 hours lots_che manuf_che model_che body_che
  © AJ System