Posts by carlaoca

carlaoca · mORMot 2

Hello friends.
1- We need to connect our ERP to a Web Service:
endpoint := 'https://securetest.aduana.gov.py/sgd3/serviciodeposito';
soapAction := 'transito';

2- The limited documentation collected:
2.1- We need to implement WS-Security.
2.2- Use this link "as an example":
https://docs.jboss.org/author/display/W … ity-Client
2.3- Security is based on certificates (DNA / Paraguay).
2.4- Sign the request (with its private key).
2.5- Encrypt the previously signed request (with the public certificate generated by DNA / Paraguay)

3- Is it possible to do this entirely with mORMot2?

4- Is there an example that could serve as a basis?

carlaoca · mORMot 2

Good afternoon friends.

1- I'm starting a new project, and we want to test mORMot for REST server.

2- We use FirebirdSQL, via UniDAC.

3- Each Query is a parameterized Stored Procedure.
Example:
select *
from clients_sp c
where c.name like _name
and c.surname like :surname_p

4- Where I could get an example, where the method receives those parameters, and return a JSON with the result of the Query ?

Kind regards.

mORMot Open Source

#1 mORMot 2 » WS-Security » 2025-08-09 20:13:40

#2 mORMot 2 » REST + FirebirSQL/UniDAC Example. » 2023-03-14 22:46:50

Board footer