Forum Discussion

Reponen's avatar
Reponen
Frequent Visitor
1 year ago
Solved

Fabric Set variable Select id from table

Hello,

 

I am pretty new with Fabric and Data factory.

I have currently proplem that my set variable selects whole row but i only need id column from table.

 

My SetVariable now:

@activity('GetDataFromTable').output.value" 
 
How i fix this?
 
 
Need Help
Pipeline
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Reponen 

     

    Thank you very much nilendraFabric for your prompt reply.

     

    For a single row,

     

    @activity('GetDataFromTable').output.value[0].id

     

    Assume the output of GetDataFromTable is as follows:

     

    {
  "value": {
    "id": 123,
    "name": "example",
    "age": 30
  }
}

     

    Then @activity('GetDataFromTable').output.value.id will return 123.

     

    For multiple rows:

     

    @array(activity('GetDataFromTable').output.value, item().id)

     

    Assume the output of GetDataFromTable is as follows:

     

    {
  "value": [
    { "id": 1, "name": "Alice" },
    { "id": 2, "name": "Bob" }
  ]
}

     

    Then @array(activity('GetDataFromTable').output.value, item().id) will return [1, 2].

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • nilendraFabric's avatar
    nilendraFabric
    Super User
    1 year ago

    Hello Reponen 

     

    Matching: Ensure the column name `id` matches exactly (case-sensitive) with your table schema.

     

     

     

    @activity('GetDataFromTable').output.value[0].id

     

    Or 

     

    @activity('GetDataFromTable').output.value.id

     

    if this is helpful please accept the answer and give kudos

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Reponen 

     

    Thank you very much nilendraFabric for your prompt reply.

     

    For a single row,

     

    @activity('GetDataFromTable').output.value[0].id

     

    Assume the output of GetDataFromTable is as follows:

     

    {
  "value": {
    "id": 123,
    "name": "example",
    "age": 30
  }
}

     

    Then @activity('GetDataFromTable').output.value.id will return 123.

     

    For multiple rows:

     

    @array(activity('GetDataFromTable').output.value, item().id)

     

    Assume the output of GetDataFromTable is as follows:

     

    {
  "value": [
    { "id": 1, "name": "Alice" },
    { "id": 2, "name": "Bob" }
  ]
}

     

    Then @array(activity('GetDataFromTable').output.value, item().id) will return [1, 2].

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Reponen's avatar
      Reponen
      Frequent Visitor
      1 year ago

      If i try to use it says that 

      Item() syntax can only be used in the filter activity or child activities of a foreach activity
      @array(activity('GetDataFromTable').output.value, item().id)

       

      This code works @activity('GetDataFromTable').output.value[0].id

      but gives only first id.

      I need a array of ids