General

Re: Best practice on REST web services

djj6677 — Tue, 27 Oct 2015 21:26:36 GMT

This might be the amusing part, but I don't know how to update the SQL tables through a web service, except by using Custom Code....

So it's a REST (WCF) web service - I just need to do single record inserts, updates and deletes...

The data connection is a secondary data source, and I've always understood that it's for retrieval, not updating, am I wrong?)

Re: Best practice on REST web services

Hilary Stoupa — Tue, 27 Oct 2015 14:49:29 GMT

Okay, sorry, I feel like we are going in circles. :) What is your custom code doing? If you are using a web service to write back to SQL, where does the custom code come in?

Re: Best practice on REST web services

djj6677 — Tue, 27 Oct 2015 00:17:58 GMT

Yes, exactly, the web service talks to the SQL table.

My preference would be to use the web service to update the tables.

regards,
David

Re: Best practice on REST web services

Hilary Stoupa — Tue, 27 Oct 2015 00:05:13 GMT

Hey, David - yah, you have carefully restrict user input with execute SQL - you'd need to use dropdowns or validation rules (or other rules to sanitize input). But I had thought you were asking about submitting to a web service - have you got a web service that talks to your SQL table?

Re: Best practice on REST web services

djj6677 — Mon, 26 Oct 2015 23:24:34 GMT

Hello Hilary,

The custom code does the really basic CRUD operations... - Insert a single record, delete a single record and update a single record. (All using secondary data sources) and the data source is an SQL Table.

So essentially I use the "Change REST URL" rule to query the source using ODATA, and then need a method to allow the user to make changes to the displayed records.

If there's a completely different approach to this, happy to consider that as well.

(I have seen a QRules command to execute SQL, but I'm a bit reluctant to do this, since it has a potential risk of SQL injection attacks...)

thanks in advance,

David

Re: Best practice on REST web services

Hilary Stoupa — Mon, 26 Oct 2015 15:53:30 GMT

SubmitToSharePointList is specifically meant for submitting items to SharePoint Lists, I'm afraid. What does your current custom code do? I can maybe help you find a combination of qRules commands that could do what you need....

Re: Best practice on REST web services

djj6677 — Sun, 25 Oct 2015 23:28:57 GMT

Thanks Reema,

Just briefly the QRules command "SubmitToSharePoint" - will that work for Web services which are NOT in SharePoint?

(Because my web Service is a WCF REST web service, just hosted on a standard web server, not SharePoint)

thanks again,

David

Re: Best practice on REST web services

Reema Daga — Sun, 25 Oct 2015 13:10:42 GMT

Hello,

Thank you for your post on infopathdev. You can use the qRules commands like SubmitToSharePoint to submit to a library and SubmitToSharePointList to submit data to a SharePoint list.

Here is the link to the blog by Hilary: http://www.infopathdev.com/blogs/hilary/archive/2012/05/30/qrules-submittosharepointlist-walkthrough-for-v4-2.aspx

Hope this helps!

Kind Regards,

Reema

Reema Daga
Qdabra® Software / InfoPathDev.com / FormsQuo / 425 999 4597 direct

Business Process Automation for Everyone – Streamline data gathering to turn process into knowledge.™

Best practice on REST web services

djj6677 — Sat, 24 Oct 2015 09:01:37 GMT

Hi everyone, I use InfoPath 2013, and have recently purchased QRules... I have a series of existing InfoPath web forms which use WCF REST Web services, querying the Data using ODATA (with InfoPath Rules) and then submitting new records using Custom Code. Now I have QRules I'm hoping to remove some of the custom code replacing it with QRules functionality.... So my question is... Can I use QRules to submit data to a WCF web service, and if so, how? (which command etc) If there is a worked example or video tutorial somewhere, that would be perfect. Many thanks in advance, David Jones