Skip to main content
February 12, 2026
Question

tostore data from http resppponse to table

  • February 12, 2026
  • 2 replies
  • 0 views

In http response I am getting IDs and codes. Each id will have multiple codes. now i need to store the code with respective Id in table. How to do it?

    2 replies

    shubhama926776
    February 12, 2026

    Are the Ids and codes coming as arrays/lists in the JSON response (like id: 123, codes: ["A", "B", "C"]), or are they coming as separate flat rows?
    If you assume like this,

    a!localVariables(
      local!httpResponse: {
        { id: 101, codes: { "A1", "A2", "A3" } },
        { id: 102, codes: { "B1", "B2" } },
        { id: 103, codes: { "C1", "C2", "C3", "C4" } }
      },
      local!flattenedData: a!flatten(
        a!forEach(
          items: local!httpResponse,
          expression: a!localVariables(
            local!currentId: fv!item.id,
            a!forEach(
              items: fv!item.codes,
              expression: { id: local!currentId, code: fv!item }
            )
          )
        )
      ),
      local!flattenedData
    )



    stefanhelzle0001
    February 13, 2026

    Please do not make us make assumptions about what your problem actually is and provide more details.