How can I get the Questions (with IDs) when I retreive the responses)

ach - that is perfect :-)

Many thanks indeed

BtB

I’m actually struggling to marry the responses to the questions … or vise-versa

Is it not possible within the response API to get the corresponding question?

When you retrieve responses (see docs) you should get an object like this for each answer in each response:

          {
            "field": {
              "id": "hVONkQcnSNRj",
              "ref": "my_custom_dropdown_reference",
              "type": "dropdown"
            },
            "text": "Job opportunities",
            "type": "text"
          },

When you retrieve form definition (see docs) you will see both id and ref for each field. You can use id to pair fields & answers (refs are editable when building the form).

Mathio - many thanks, please excuse my late response …

The issue I had was due to the Matrix type of question / response … the ids are further nested than those from a simple question.

But I worked it out regardless.

BtB

Hey @bill-the-badger! Can you let us know what was the solution you've found? Thank you!

Hi Gabi - Certainly …(although you probably do not use the same syntax that I am using)

I loop through the responses, extracting the following:

$_current.answer = GetJSONObj ( $_array.answers ; $_loop.count ) ;

$_field = GetJSONObj ( $_current.answer ; "field" ) ;
$_type = GetJSONObj ( $_current.answer ; "type" ) ;
$_id = GetJSONObj ( $_field ; "id" ) ;

If $_type = "choice", then I need to get the answer from a different path @ GetJSONObj ( $_cur.answer ; "choice.label" )

I then filter the form questions based upon the current $_id - this will give me the matching question to the current answer, viz. GetJSONObj ( $_form.questions ; \"id\" ) = \"" & $_id & "\" " ) …

I need to massage the question a bit, again dependant on the answer type - but it work fine.

HtH

BtB

The issue I had is that in the matrix type of questions, the id is located further down in nested arrays … that is why I used a filter on ANY id, not just the first question id ...