Looking for an experienced Azure Logic Apps developer for a small Logic App
$250-750 USD
Kapalı
İlan edilme: 6 yıldan fazla önce
$250-750 USD
Teslimde ödenir
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): ([login to view URL])
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 CSV files from SQL data sets.
I have configured quite a few Flows for use in SharePoint, Dynamics 365, and developed custom connectors. My experience with Azure Logic App is not at the level of "Expert" but I am sure I will be able to manage your requirement.
Would be great to connect and discuss the implementation for us to be on the same page.
Thanks,
Regards,
Rajesh Menon
I have experience with logic apps whcih I have already developed for many purposes, using logic apps, functions and storage to reach the expected requirements. I also have skills in .NET, C#, ASP.NET WebAPI, SQL Server, T-SQL