SQL Api - Execute SQL via external POST queries
Description
Highlights
About the Extension
Our plugin offers an extremely flexible, external SQL execution option. With ease, you can initiate SQL queries through simple POST requests to the API, and the resulting output is provided to you in a user-friendly JSON format. In addition, we ensure the highest level of security by securing access to the API through IP filtering or the use of keys. This ensures that your data and queries are always protected and controlled.
Every "SQL query" is logged in the database and can be read out if required.
Some examples would be to retrieve the stock levels of all products or to control the product status of various products.
The following systems have already tested our SQL Api: SAP Business One, XENTRAL, Sage.
Explanation of the requests
Send POST request to the following endpoint::
https://***SHOPWAREURL***/api/kzphSqlApi/execute
POST Parameter:
hash = the secret key, if necessary (see plugin configuration).
cmds= the SQL queries which are to be processed in sequence. Separate these with ;.
Example cUrl:
curl
--location 'https://***SHOPWAREURL***/api/kzphSqlApi/execute'
--form 'hash="ThisIsASecret!"'
--form 'cmds="SELECT * FROM `order`LIMIT 5; SELECT * FROM kzph_sqlapi_log ORDER BY created_at DESC;"'
Detailed documentation and PHP examples are available here::
https://www.konzeptphase.com/fileadmin/SQLApi-Documentation-Example.zip
Do you have any questions or problems? We are available for you at any time.
Either via the Shopware ticket system or by e-mail to service@konzeptphase.com
Details
- Available: English, German
- Latest update: 3 December 2024
- Publication date: 10 October 2023
- Version: 1.0.1
- Category: Administration
Resources
Reviews (1)
Endlich kann unser ERP noch besser mit Shopware interagieren!
Das löst ein langes Problem auf unserer Seite.
Wir benötigten eine schnelle Möglichkeit um Lagerbestände und Bewegungen abzurufen,
da Shopware von Haus aus keine ERP Funktionen anbietet.
About the Extension Partner
Konzeptphase, Florian Bettzieche
Partner Status
-
Shopware
Extension Partner
Details
- Ø-Rating: 4.9
- Partner since: 2022
- Extensions: 5
Support
- Based in: Germany
- Speaks: German, English
- Response time: Very quickly