Looking for an experienced Azure Logic Apps developer for a small Logic App
Ngân sách $250-750 USD
Looking for an experienced Azure Logic Apps developer for a small Logic App that will create csv files from result sets returned from a sql server stored procedures. The created csv files then needs to be posted to a http endpoint using multipart/form-data. The required steps in more detail are:
1. Trigger logic app once every x minutes
2. Run a sql query that returns a result set that represents 1 or more datasets that need to be made into csv files and posted to the http endpoint (columns of result set are id(string), listname(string), dataset_id(string))
3. If result set count is zero then exit
4. If result set count is greater than zero then post authorisation header request with username and password to http endpoint to get session token for subsequent posts to endpoint
5. For each row in sql query result set:
a. Call stored procedure sp_return_dataset_update with dataset_id as parameter to return the dataset as a result set
b. If return set does not contain rows, set response_message string variable to ‘dataset contained no rows’
c. If return set contains rows,
i. convert the returned dataset to a csv file
ii. HTTP post to endpoint: In Body, post id, name and csv file as multipart/form-data, along with auth session token in header, to the http endpoint
iii. Set response_message string variable to http response json
d. Call stored proc sp_dataset_update_response with parameters of dataset_id and response_message
The http endpoint that needs to be accessed is part of the FastField API (see attached API pdf doc - Add/Update Lookup List section). Also, here is a link to an explanation of utilizing the same FastField API via Zapier integration with Google Drive (please note, the required approach is to be Logic Apps only without use of Zapier or Google drive integration): ([url removed, login to view])
11 freelancer đang chào giá trung bình $564 cho công việc này
Hello, I am an experienced web and mobile developer on this site. I have a great profile by completing over 100+ mobile apps and site tasks and got the great skills and experiences so far. [login to view URL] Thêm
Dear,Sir I have experienced in developing Azure Web service and mobile App. I will work very hard and best for you. Best Regards
Hi - are you able to connect with me to discuss this further? thanks. Hi - any chance of taking this forward? Hi there, Greetings! I understand you have a requirement to configure Azure Logic App to create Thêm
Hello There, We have 3+ yr exp. with azure. We can do as you mention in requirements. We can discuss more over chat. Thanks.
Hello, As per your requirement. I will be perfect and suitable for this project. I have more than 6 years experience in ASP.NET and the .NET Framework using C#, HTML, JavaScript, XML, CSS, AJAX, ASMX Web Services, Thêm
