This topic is locked
[SOLVED]

 how a clients, can retrieve their data as json from phprunner app?

9/24/2019 7:29:50 PM
PHPRunner General questions
Myr0n author

Hello everybody
One of my clients ask me: How a client, can retrieve their data (orders including details) and the products catalog from their mobile applications as json, from my phprunner application without accesing my MySQL db?
This client does not want to invest in a rest api.
Somebody could help me to answer that question please.
Thank you so much.

lefty 9/24/2019



Hello everybody
[size="2"]One of my clients ask me: How a client, can retrieve their data (orders including details) and the products catalog from their mobile applications as json, from my phprunner application without accesing my MySQL db?[/size]
[size="2"]This client does not want to invest in a rest api.[/size]
Somebody could help me to answer that question please.
Thank you so much.


This might help you on your project . Click Here . You will have to change your project to decode and / encode to satisfy your requirements. There are already some ideas in the source code, if you look at the Commonfunctions file . Here are some more ideas for conversion, Click HERE . If your client is running a "mobile application" they can use cross origin policy or JSONP to connect and use JSON data , but is very intensive coding to connect with your project if you are using it for the whole project. Just google JSONP and you will get a lot of articles when it comes to mobile apps and external URL's .
Also heard REST API may be coming in 10.4. If that helps.

A
acpan 9/26/2019

Hi John,
Do you have more info on the Rest API coming to 10.4?
I may just wait for it to release before i start to do my own api from scratch in a few months time.
ACP
>Also heard REST API may be coming in 10.4. If that helps.

lefty 9/26/2019



Hi John,
Do you have more info on the Rest API coming to 10.4?
I may just wait for it to release before i start to do my own api from scratch in a few months time.
ACP
>Also heard REST API may be coming in 10.4. If that helps.


I don't have any info , just heard it's coming. 10.3 is in beta so it may be awhile. If you want to convert manually ( for clients use ) you can export all your product data to CSV format then go to this website and it will convert it to JSON for you. Here

Not sure how you would get data without querying your database if you need to do it programmatically . You Need a function to fetch the records then encode the results in JSON format.

Myr0n author 9/27/2019

Thank you so much for the information.