Questions tagged [azure-logic-apps]

1

votes
2

answer
44

Views

Azure Transform XML to JSON

I'm trying to transform the following XML into JSON using Azure liquid mapping to find the session ID. 0 No error A VALUE I'm trying to use this liquid file to convert the XML to find the sessionID in JSON. { 'Session': '{{content.soap:Envelope.soap:Body.LogInResponse.SessionID}}' } This just retur...
Watsyyy
1

votes
1

answer
427

Views

Azure Logic App - expected failure in request causes entire run to be “failed”

I have a scenario where I will be making a third party API request to check if a particular set of data exists, however in the event that it doesn't the request returns a 404. That's fine, and I can react accordingly using the 'run after failure' condition in the logic app, however in the Overview o...
Bauza23
1

votes
1

answer
286

Views

What are the properties in an ARM template for a Dynamics 365 CRM logic app connector?

Logic app connectors are closed source and the 'Automation Script' option in the Azure portal strips the authentication portions of the properties node from connectors. This is what the portal hands you when you script out the ARM template for a logic app which talks to CRM. { 'comments': 'Generaliz...
Josh
1

votes
1

answer
334

Views

How to validate if a string property is numeric on a Logic Apps Liquid template?

I'm creating a Liquid template, and I need to validate whether a string property in my JSON payload is numeric (contains only digits). I've tried to implement the tip suggested here {% assign test = 'A string' | plus: 0 %} {{ test }} {% assign test_d = '123456' | plus: 0 %} {{ test_d }} {{ test }}...
Paco de la Cruz
1

votes
1

answer
177

Views

How to check if a container exists, and if not then create one

I am trying to design an Azure logic app that will connect to my FTP server and upload my files to a blob (or container, not really sure how the hierarchy works) whenever a file is added to my server. I have folders in my server by date (01-22-2018) etc. and I would like to bring this structure over...
andrewbuikema
1

votes
1

answer
1.3k

Views

Is it possible to send files and folders from FTP to Azure blob storage in timely basis?

i am trying to copy files from FTP to Azure Storage using logic apps, my app was fully functional when a file is getting added in the ftp location but not folders. i dont see any settings to change to copy the folders also.
sanjay
1

votes
1

answer
303

Views

Failed to fetch swagger with error message: Failed to fetch. Ensure you have CORS enabled on the endpoint and are calling a valid HTTPS endpoint

I'm trying to run a Function from a Logic App. I made the mistake of experimenting with an API definition on a production Function App. I've redeployed the last working commit and restarted the Function app but I still get this error on the Logic Apps side. How do I get back to where I was?
Chris76786777
1

votes
1

answer
1.5k

Views

Arguments to a Logic App via HTTP GET trigger

In a Logic App, is it possible to send arguments via the URL? The first step in the app is a 'When a HTTP request is received' trigger that generates a URL. For example: https://prod-28.northcentralus.logic.azure.com:443/workflows/xxx/triggers/manual/paths/invoke?api-version=2016-10-01&sp=%2Ftrigger...
crowhill
1

votes
1

answer
323

Views

How to retrieve integer values of an option set using text inside an azure logic app

I'm trying the Azure Logic apps to create dynamics 365 crm records, but I'm stuck with the following: I don't know how to search a lookup value using a text field. The process is simple. I receive a JSON message and I parse it. It has 3 fields which I need to map to my crm record. Please check the...
DuncanW
1

votes
1

answer
658

Views

Logic Apps - “Authorization Failed - The authentication credentials are not valid”

I have a logic app that I can call successfully using any rest client, but when my application tries to call it I get a 401 { 'error': { 'code': 'Authorization Failed', 'message': 'The authentication credentials are not valid' } } The trigger is an http request and I am using the exact one copied fr...
user1048175
1

votes
1

answer
325

Views

Logic app not tracking custom property as guid to log analytics, why?

I'm, currently have using a Compose connector in Logic app to track properties extracted from the trigger, the value is a Guid extracted from an xml string inside a Json object. But for some reason trying to log a Guid to log analytics dosen't work. But when i just write some random string it loggs...
John
1

votes
1

answer
115

Views

Azure Logic Apps Liquid connector – transform HTML to XML

We are having HTML response, need to transform it to XML/JSON. Anybody can help, how to achieve it through an Azure Logic app and Integration Account. Appreciate the help.
Paresh Bijarane
1

votes
1

answer
170

Views

Logic App Sharepoint Create File not working as expected

I created a set of logic apps to have a very specialized integration between D365 CE (CRM) and SharePoint. I am using the Notes entity in CRM to allow the user to upload a docx file using the native CRM UI. The Logic app finds the file (using CRM List Items action) and returns the file as a base64 e...
Eccountable
1

votes
2

answer
58

Views

custom input & output fields for azure function

I am not sure if this is an option. I require it badly, and cannot find any references of it. When integrating between an HTTP Triggered Azure Function within your Logic App flow, you are requested to pass a body object for the function to digest: I am hoping for a way to customize the Request Body...
Omer Shukar
1

votes
1

answer
154

Views

Passing Dropbox file contents to an Azure Function from a Logic App

I am trying a sample app with the workflow Wait for new file (csv) in dropbox folder Load the file contents Pass the file contents to an azure function to further process I am getting stuck on how to pass the file contents to the azure function. I keep getting an unsupportedmediatype error with 'M...
Bernard
1

votes
0

answer
60

Views

How I Can do xml to json conversion using xsl in C# or using azure logic apps

I am trying to convert Xml to Json using XSLT file but the Jsonx that i got back after conversion , tried converting the same into Json but it is not in format of Json i need, used below code for conversion: XPathDocument mydata = new XPathDocument(xmlPath); //Create a new XslTransform object. XslCo...
Divya Ghai
1

votes
2

answer
336

Views

How to separate text values from string in JSON payload

Could someone point me in the right direction please? I am trying to extract specific text/numbers from a json payload. I can access/isolate the full string of text by using triggerFormDataValue('text'). The text in question may contain 'sendSMS 1122334455 actual message' as its actual value Is ther...
tcbwazi
1

votes
2

answer
381

Views

Azure Logic Apps - Office 365 Connector - Use individual user accounts

I have the following scenario: I'm trying to automate creation of Events in Calendars in Office 365 exchange with Azure Logic Apps. Right now I'm using a generic account that would send meeting invites to the users. It gets sent to Sales Rep and the Customer. I would like to modify that so - the mee...
1

votes
1

answer
2k

Views

Azure Logic Apps : Get HTTP Request Header Key Value into Conditional Check

I've created a Logic App in the Azure Portal. It's triggered by an HTTP POST and in that POST I have set a Key called 'jmb_private_key'. After the Logic App receives the HTTP Request I've placed a Conditional which I want to check for the Key. Checking for Header CONTAINS 'myvalue' does not work....
jmb-mage
1

votes
0

answer
183

Views

Managing Administrators for On-prem Data Gateways without Power BI

I have been able to install an On-prem Data Gateway (OPDG) and configure it for use within my Azure Logic App. However, to administer the OPDG in Azure, I need to add administrators to it. I am not using Power BI, so I cannot use the screens described in https://docs.microsoft.com/en-us/power-bi/ser...
Mark A Johnson
1

votes
0

answer
105

Views

Send an attachment in gmail with logic app failed

I have a logic app that needs to read data from a file on ADLS, take content, and that content sent as an attachment using Gmail. I see from logic app documentation that size of attachment in Gmail is 30mb ( https://docs.microsoft.com/en-us/connectors/gmail/ ), so I have a condition if the file siz...
DraganB
1

votes
1

answer
41

Views

Looping Functoid with 856 Source

I am trying to map from an 856 to an internal XML schema using the azure logic apps mapper(derived from BizTalk mapper). The internal structure is relatively simple with a header record and a child detail record. I have connected the HLLoop1 node to the ExDPASNItemTable node as shown in the screen...
Aromanin
1

votes
1

answer
40

Views

Azure create one drive file on post request to logic app

I am creating an Azure Logic App which will trigger on Post request which'll create a file on one drive using the data passed to it. I am requesting through Postman, attaching the file in form data. But I don't know how to handle this request and get file content to create a file in logic app. Thank...
Rahul Chavan
1

votes
1

answer
47

Views

Create Azure Logic App Alert for 24 Hour Period

I have an Azure Logic App that processes an email that is received once a day. I would like to setup an alert on the logic app that notifies me if the 'Runs Succeeded' metric occurs less than 1 time in a 24 hour period. (In other words, the email wasn't received for that day.) However, the greates...
1

votes
0

answer
158

Views

In azure logic App how to pass Cookie to Http request

In azure logic app by calling first Http endpoint we need to get the cookie and pass to the second endpoint. But while passing second API, I am passing in header and it is sending but the response is wrong(text/html). But When I checked by using postman it worked fine got response in JSON(applicati...
vikram
1

votes
0

answer
272

Views

azure logic app HTTP bad request

i'm using HTTP post request in azure logic app to send data to Api.In my case im getting values from SQL stored procedure and put in to HTTP post request body.but when i request it's show as bad request. required format : {'UserName':'test','Code':102},{'UserName2':'test2','Code2':103} Error format...
Ashan Nuwaneth
1

votes
1

answer
35

Views

How can I track the delivery status of the sent email in “Send an email” Azure Logic App Outlook Connector

When using Azure Logic App Office 365 Outlook connector - 'Send an email', is there a way to find out if the email was actually delivered or not to the recipient so as to take a specific action based on the failure? I used an invalid email ID in the connector, but the action of sending email is show...
Akshatha Pai
1

votes
1

answer
150

Views

EDIFACT DELFOR Decoding in Azure Logic Apps

I am moving from X12 into other formats with Logic Apps + Integration Account, without much EDI or LA experience. Here is my DELFOR example: UNB+UNOA:2+OURCODE:ZZ+THEIRCODE:01+180523:1005+157' UNG+DELFOR+OURCODE+THEIRCODE+180523:1005+157+UN+D:96A' UNH+15700001+DELFOR:D:96A:UN' BGM+241+201805231005-1...
Tom Schulte
1

votes
0

answer
22

Views

Why would a portion of my URI be replaced with the text '<DELIMITER>' in a Logic App definition?

I have an Azure Logic App which makes a GET call to an API app. Building the URI is a little complex. The JSON definition looks like this: 'uri': 'https://my-api-staging.azurewebsites.net/authorize/@{encodeURIComponent('R')}/@{encodeURIComponent(body('WorkflowStepArgument')?['Properties']['WorkflowO...
Jude Fisher
1

votes
1

answer
39

Views

Changing a HTTP Header Name using a policy

My Scenario: I am using API Management to front a logic app that is going to represent my on boarding process which involves calling my security service. To the outside world I want the consumer to pass me the user credential inside the Authorization Header. My Problem Part 1: Logic Apps does not a...
1

votes
1

answer
102

Views

Azure LogicApp Fails on SQL Connection

I am trying to call a stored procedure in Azure Logic App. However, whenever I am trying to connect to DB & select procedure or execute app I get the following error. ` { 'status': 400, 'message': 'Can not add property StartTime to Newtonsoft.Json.Linq.JObject. Property with the same name already e...
Rahul Bagal
1

votes
0

answer
212

Views

Azure Logic Apps- maximum buffer size

I am using a HTTP connector to download a file using the get Request. Have set Allow chunking to On but still getting the error 'Http request failed as there is an error: 'Cannot write more bytes to the buffer than the configured maximum buffer size: 104857600.'.' Tested the endpoint with a HEAD re...
1

votes
0

answer
198

Views

Logic Apps: Servicebus Polling trigger processes message multiple times

I have a Logic App polling a servicebus queue. With concurrency-control on the Logic App I've limited it to max 5 concurrent instances. I use the trigger 'When a message is received in a queue (auto-complete)' When putting, for example, 8 messages on the queue, it processes 5, then after the polling...
jcools85
1

votes
2

answer
493

Views

Save the Response from HTTP to Blob Storage using Azure Logic App

Is it possible to save the response from the HTTP request(First Step) into the Blob Storage(Second Step) while using Azure Logic App. Thank you.
Rocket Singh
1

votes
1

answer
143

Views

Automatically trigger Security Center Playbook

I've created a Playbook in Security Center and can manually trigger the Playbook by going to a Security Alert and clicking 'Run' on my Playbook. Now I would like to automatically have this Playbook triggered whenever there is a new security alert. Initially, I tought that these Playbooks were going...
1

votes
0

answer
28

Views

logic apps with multiple sql connections

i have a scenario as below. retrieving data from topic(xml). finding an element value(for ex: xxx ) from xml (using xpath) depending on the value i need to connect to different sql servers. i.e. if XXX is 10 then connect to SQLServer_1 if XXX is 20 then connect SQLServer_2 the value is dynamic here....
Chitti
1

votes
0

answer
70

Views

“Append to array variable” action performs badly

I have a logic App that uses an Array Variable as a buffer to hold messages. Each message is just over 2K bytes. In the Portal if I navigate to the Run History, select a run, and then look at the Run Details I see this: That's 27s to add 100 2K messages to an array. This seems a very long time for...
Jason Steele
1

votes
0

answer
59

Views

Azure Logic App returns 404 with valid Project Online ODATA query using /_api/Projectdata

I want to filter and select Project Online data using Enterprise Custom Fields (ECF) in an Azure Logic App. I start with the out-of-the-box Project Online connector to trigger on project publish, then list project and task details. Using the default connector, I can return project data but it doe...
John Palmer
1

votes
0

answer
36

Views

Azure LogicApp Metrics

I have a LogicApp which runs for every 2 minutes. All runs in this LogicApp has failed between 4:45pm to 5:00pm. when I check for the metric Run Failure Percentage under 'Metrics' in the Azure portal with time granularity as 15 minutes and aggregation as Average, it shows me Run Failure Percentage...
Yuvaranjani
1

votes
1

answer
181

Views

Run .Net and Python applications on Azure Data Factory?

I am trying to create a pipeline in Azure which involves running .Net applications and python applications as part of the workflow. These applications read/write to ADLS and Azure databases. I am wondering what are the best tools for the job. So far I have landed on using ADF, with Azure Batch/Custo...
Gadam

View additional questions