Set Variable to lookup first row value with white space in property name

  • Hi,

    How can I set the value of a variable from a Lookup activity when thw property name hase a white space? I'm trying to do it this way but fails:

    "value": "@activity('LookupMaxRecordId').output.firstrow.Record ID#",

    Find the complete code below:

    Thanks!

    *************

    {

    "name": "pipeline8",

    "properties": {

    "activities": [

    {

    "name": "LookupMaxRecordId",

    "type": "Lookup",

    "dependsOn": [],

    "policy": {

    "timeout": "7.00:00:00",

    "retry": 0,

    "retryIntervalInSeconds": 30,

    "secureOutput": false,

    "secureInput": false

    },

    "userProperties": [],

    "typeProperties": {

    "source": {

    "type": "HttpSource",

    "httpRequestTimeout": "00:01:40"

    },

    "dataset": {

    "referenceName": "***_Incidents_test_maxid",

    "type": "DatasetReference"

    }

    }

    },

    {

    "name": "Set variable1",

    "type": "SetVariable",

    "dependsOn": [

    {

    "activity": "LookupMaxRecordId",

    "dependencyConditions": [

    "Succeeded"

    ]

    }

    ],

    "userProperties": [],

    "typeProperties": {

    "variableName": "maxRecID",

    "value": {

    "value": "@activity('LookupMaxRecordId').output.firstrow.Record ID#",

    "type": "Expression"

    }

    }

    }

    ],

    "variables": {

    "maxRecID": {

    "type": "String"

    }

    },

    "folder": {

    "name": "Test"

    },

    "annotations": []

    }

    }

    ***********

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply