Find Jobs
Hire Freelancers

Looking for an experienced Azure Logic Apps developer for a small Logic App

$250-750 USD

Closed
Posted over 6 years ago

$250-750 USD

Paid on delivery
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])
Project ID: 16099830

About the project

10 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average $565 USD for this job
User Avatar
Dear,Sir I have experienced in developing Azure Web service and mobile App. I will work very hard and best for you. Best Regards
$400 USD in 10 days
5.0 (5 reviews)
5.0
5.0
User Avatar
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
$750 USD in 5 days
5.0 (2 reviews)
4.3
4.3
User Avatar
I'm very good with data driven web apps, especially those involving json and/or Ajax
$555 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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
$755 USD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$555 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello There, We have 3+ yr exp. with azure. We can do as you mention in requirements. We can discuss more over chat. Thanks.
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Ringwood, Australia
5.0
2
Member since Jan 11, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.