title: How to extract the value from a json object in Azure Data Factory
body: <p>I have my ADF pipeline, Where my final output from set variable activity is something like this <code>{name:test, value:1234}</code>,</p>
  <p>The input coming to this variable is</p>
  <pre><code>{
      &quot;variableName&quot;: &quot;test&quot;,
      &quot;value&quot;: &quot;test:1234&quot;
  }
  </code></pre>
  <p>The expression provided in Set variable Item column is <code>@item().ColumnName</code>. And the ColumnName in my JSon file is something like this <code>&quot;ColumnName&quot;:&quot;test:1234&quot;</code></p>
  <p>How can I change it so that I get only <strong>1234</strong>. I am only interested in the value coming here.</p>