Connection with MSSQL and php

[Stelios Geo]

Hello! Im afraid i do not understand call it from where? I only call it on the load, just excaclty as the example with the integrated database you have in docs do i need to call it before? I can upload some screenshots with thei events, ifthat helps you
Thank you..

[Evgene Karachevtsev]

Could you please give us public link to your application: http://docs.appery.io/documentation/s... and steps to reproduce the error

[Stelios Geo]

Sure Evgene, there you go:
http://appery.io/app/mobile-frame?src...

Well actually I dont get an "error" but in debug mode from chrome, the Network status of my php file is (canceled).
What have I done wrong?

Thank you.

[Kateryna Grynko]

Hi,

As we can see, you invoke SQLService on Load event, with proxy disabled. What parameters do you need to pass to server? Only 'q'? Why do you pass 'appery-rest' and 'appery-transformation'?

[Stelios Geo]

Hi, yes proxy is disabled as Maryna told me. I pass only q as parameter, the others (appery-rest and appery-transformation) took them from the example.. i guess they are not needed, right? how can this play anyway?

Thank you for your replies

[Kateryna Grynko]

Hi,

Create a proxy here https://appery.io/proxy/ and specify it in service settings.

As we can see from Postman, an incorrect JSON is generated on your site:

However, you can use such service, just create service response parameters:
http://docs.appery.io/documentation/r...

[Stelios Geo]

Hi Katya,

Yes i had done this thing with the proxy, but the JSON format seems to be valid, doesn't it? I mean the http://jsonlint.com validates my response :-/
The fields 0, 1, 2 are not used, I just use the USR_FULL_NAME one.
How my JSON should be generated?

Thank you..

[Kateryna Grynko]

Sorry, I misunderstood you, I thought you did not need such parameters.
It is valid. Let us know if you have any other questions.

[Stelios Geo]

Well, as a matter of fact, i get the following error in my chrome:
GET https://api.appery.io/rest/1/proxy/tu... 400 (Bad Request) and link says :
{"code":"PTCT010","description":"Mandatory parameter 'appery-rest' is missing"}

even though i already have this parameter and the value is my Proxy ID just like the doc: http://docs.appery.io/documentation/s...

[Evgene Karachevtsev]

Hello Stelios,

You don't need to add any request parameters like "appery-rest" manually. You should delete them. Your service should have one request parameter "q" and use Appery,io proxy.
But you have changed file "StartScreen.js" manually. So it won't change from appery builder anymore. So you need delete it and then execute "undo all source changes"