Azure Function App - Node - SQL Server/MySQL

Job ID: 33655186

Budget: £20 – £250 GBP

Hi,

I need two Azure Function apps written in Node.js to decode simple JSON and insert into:

1) MSSQL database table
2) MySQL/MariaDB table.

Table structure is very simple

device_id : string (<200 characters)
sensor_date : datetime/timestamp (valid date format)
sensor_name : string (<100 characters)
sensor_value : float

i.e.

e5e93ec2-2108-4b32-92f7-a00a1a0f8825
2022-05-09 15:54
TEMPERATURE
22.44

(JSON attached, timestamp is the time received, data is in the 'result' collection, device is the device id)

Freelancer must supply code for the Azure Function apps which can be loaded into our tenancy.

Code should be well commented and robust (i.e. sanitise inputs).

I expect this would be <3 hours max.

Code must be tested in Azure (not generic Node)

Thanks

Joe