Hello Team; I was looking at this https://www.youtube.com/watch?v=2SCvzw0L27o&t=1273s and wandering how could we use the FD and FDBatch (similar to what is been used in this sample) for HTTP POST/UPDATE/DELETE methods? I was able to leverage the sample and build the httpget for what I'm looking fo…

All you need to do is create your service contract interface with the operations you want (PUT, POST, etc.) and the routes. [ServiceContract] [Route('customers')] ICustomerService = interface(IInvokable) ['{D2981778-B681-4D4B-B95E-9816B5C7F1D1}'] [HttpPost, Route('')] procedure Cr…

You should create a method that receives parameters for the field values, and then execute the SQL statement using FDQuery inside the method implementation.

Hello Wagner; Do we have any sample of defining the Put / Delete methods ...most of the demos for service call are based on Get and in my use case the client side is not a Delphi. I would like to create a generic services to do the Get and Put functions. I had a good progress on Get based on the d…

Hello Wagner; Would you please review my resent question in respect to your respond and get back to me? I would like to see some real implementation for PUT & DELETE & UPDATE methods. The end result is important; how we could do that (implement it) – using FireDAC or Aurelius is not important for …

comment: I meant to see the real sample for httpPOST, httpDelete, etc. Thank you for help in advance.

Hello Team; do you have any update on this subject for me? I need a real sample which shown how we could use the [httppost] / delete / update methods, have a service running under windows and let us to add a record to database by invoking that method outside of Delphi. Assume the client applicatio…

Wagner; many many thanks. I will explore this and keep you posted if anything else came-up. At the meantime; I've two Q: What would the best way to handle the varbinary (in DB world, blob) in methods? We want to use user/password as parameters when the service is called from client side (when cli…

Hello Wagner; Would you help me to use a proper type casting for loading the TBlob field(s) into table when posting the data? Assume the table has this structure: CREATE TABLE [dbo].[CUSTOMERS]( [ID] [int] NOT NULL, [NAME] nvarchar NULL, [COUNTRY] varchar NULL, [RATE] [decimal](6, 4) NULL, […

It could be good to create new different topics for different subjects. You can read a TBlob using AsUnicodeString, AsBytes, or use SaveToSTream to save the content to a stream. Then you can use such data as you wish with your preferred database component - FireDAC, for example.

Thanks. I've tested that using the SaveToStream and LoadFromStream using blob type / although seems is working but the data saved in the field is not the same as original one passed through the httppost. I will create a new request | topics for this to get more help. SG.

Post, Update and Delete methods

BIZ TMS XData

Topic		Replies	Views
Response codes TMS XData	9	967	August 12, 2020
Compress Middleware and Tstream TMS XData	14	314	November 14, 2024
Web Core Request URLs TMS WEB Core	13	1290	February 13, 2021
XdataServer Response TMS XData	3	415	July 28, 2021
Is it compulsory to add all columns as property when we create a Entity class for a table in DB? TMS Aurelius	8	509	July 14, 2023

Post, Update and Delete methods

Related topics