Azure logic apps http connector does not parse json in queries

Question

    {
      "Query": {
        "inputs": {
          "headers": {
            "Content-Type": "application/json"
          },
          "method": "GET",
          "queries": {
            "f": "json",
            "temp": "\"test\": @json(body('http'))['candidates'][0]['location']['x']"
          },
          "uri": "https://testurl.com/restApi"
        },
        "runAfter": {

        },
        "type": "Http"
      }
    }

It reads "temp" as "test" : @json(body('http'))['candidates'][0]['location']['x']"

If I change this line to

    "temp": "@json(body('http'))['candidates'][0]['location']['x']"

It read the correct value from json. Not sure if its a bug, or I am missing some syntax.

Community · Accepted Answer · 2017-05-23 12:10:33Z

3

You may try what Steven answered (https://stackoverflow.com/a/44062649/7997843) or this which is more explicit to me:

"temp": "@concat('\"test\":', json(body('http'))['candidates'][0]['location']['x'])"

I suggest you to read about string interpolation in the workflow definition language here: https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language#Expressions

Your case seems to be a limit case. Either you begin your expression with @ ou @{ and then the name of your function or you can begin with a string but then you won't have any choice but to use @{

edited May 23, 2017 at 12:10

CommunityBot

11 silver badge

answered May 19, 2017 at 7:53

Julien B.

663 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Steven Van Eycken · Accepted Answer · 2017-05-19 06:13:03Z

2

Can you try with the following syntax:

"temp": "\"test\": @{json(body('http'))['candidates'][0]['location']['x']}"

answered May 19, 2017 at 6:13

Steven Van Eycken

5663 silver badges8 bronze badges

Collectives™ on Stack Overflow

Azure logic apps http connector does not parse json in queries

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related