This topic is locked
[SOLVED]

 New REST API Feature

4/1/2020 11:31:19 AM
PHPRunner General questions
S
salus1 authorDevClub member

Just installed the latest build of PHPRunner Enterprise and saw the new "Add New REST API Connection" feature. I know it's just been released but is there any more info on this new capability or, better yet, any working demonstrations?
Thanks!

woodey2002 4/1/2020
S
salus1 authorDevClub member 4/1/2020

Holy Cannoli! Thanks for this info. Based on this I implemented a REST view based on product data in a MySQL database in under 2 minutes using the following URL...
https://xlforms.net/productlist.php
I've been using web-enabled Excel spreadsheets to work with REST services and SQL databases and put together an examples database at...
https://xlsql.net
There are some demo scripts which readers may find helpful, especially regarding formatting query results in JSON.
New question came up, though. May of the examples outlined in the blog post reference a v1.php file. Anybody know where to acquire this file?
curl "http://localhost:8086/api/v1.php?table=order%20details&action=view&editid1=10248&editid2=42"

Sergey Kornilov admin 4/1/2020

This file is a part of PHPRunner 10.4. No need to "acquire" it, you already have it.

S
salus1 authorDevClub member 4/1/2020

Sorry to be thick but when I look in the Output folder I can't locate the the "api" directory of "v1.php" file.
What am I missing?

Sergey Kornilov admin 4/1/2020

Did you enable the REST API per that article?

REST API

As a first step enable REST for your project under Miscellaneous->REST API.

S
salus1 authorDevClub member 4/1/2020

Sorry, my bad. Thanks for this info and for the whole PHPRunner experience.

Best regards

Rob