Update SQL Server Data with WIX

Ask the community
,
1

I’m trying to develop a WIX Web Page in which the user can write data that should be actualized in a SQlServer DB.
To do this I think that the steps could be 1. The user writes the data in de page. 2. this data actualize a Collection DB. 3. The Collection DB Data is exported as a JSON file. 4. The SQL Server updates the table with this new data.
I’m new in WIX code, but I guess it could exist a simpler method to do this procedure.
Could anybody help me with this?
Thank you,
Arturo Villar

2

If you need a JSON file to update your SQL Server you could do what you already wrote. That way you can sync data using JSON files between the two. You could also use services like Zapier or similar I would guess to populate and handle the JSON file outputs.

3

Thank you Andreas. Really I don’t need a JSON file to update my SQL Server. I prefer to avoid JSON files, but I don’t know how connect the SQL Server DB without these files. I’m looking for a simpler and more direct way to update the SQL Server DB from the WIX page. Is it possible?

4

Hi,
I recommend following this article which explains more about exposing a site API.

Good luck!
Tal.

5

Thank you Tal. I’ll study it

6

Hi, I have a form https://www.mortgagefree.info/mrinaltest
And I want to post the submitted data to SQL Server db or Can I call my API other then wix to post the same data.

7

You can connect to an external database .

Or, if your SQL Server has an external API, then you can use the API to submit queries to the database. Here is some material that will help you with that: