Forum Discussion

MarotReply's avatar
MarotReply
New Contributor II
5 years ago
Solved

Mappping element of a Subarray of a JSON document in mapper snap

Hello, I have an issue with splitting a JSON document in a mapper. In short, this document is received via a REST Get Snap and certain elements of it should be mapped to certain names, think for ex...
  • dimitri_hristov's avatar
    dimitri_hristov
    6 years ago

    Hi,

    I tried to recreate the error by parsing the data from the original post, and yes, the CSV Parser threw an error. Still, the desired data from the .csv file were present on the output of the CSV Parser Snap, correctly transformed into JSON format. I too skipped the first 5 lines by using the “Skip lines” property in the CSV Parser.
    However, by selecting the “discard error data and continue” option in the drop-down for the Error View in the CSV Parser, the problem disappeared altogether. No error, and the CSV data was correctly parsed.

    BR,
    Dimitri

cstewart's avatar
cstewart
Former Employee
7 years ago
Copy LinkReport

In the documentation for the REST Get Snap, there is an example for response form marketo:
REST Get Pagination: Marketo
For Marketo, set:

Has Next: resultdoc.moreResult
Next URL: “/rest/v1/activities.json?nextPageToken=” + resultdoc.nextPageToken + ”&activityTypeIds=1&activityTypeIds=12”

  • MarotReply's avatar
    MarotReply
    New Contributor II
    5 years ago
    Copy LinkReport

    I’ve tried that but it causes the same issue as with one mapper.
    The elements of the subarray still get combined instead of being mapped to separate arrays.

    The issue is really that the subarray is an array of arrays, which I’d like to reproduce. Instead the mapper produces elements, each of wich contains an array of all of one type of subvalue from the different subarrays in the input.

    Sorry I just noticed that the formating in the JSON didn’t survive copying which doesn’t help make that obvious.

    • ptaylor's avatar
      ptaylor
      Employee
      5 years ago
      Copy LinkReport

      Yes, I’m not seeing any nested arrays in the JSON input or output you posted, except for the one where you’re saying that this isn’t what you want. Try posting the input and desired output with the Preformatted Text feature in the editor (icon looks like </>). That will also prevent the double quotes from getting inserted as left/right versions like in English text, which is invalid JSON.

      [
    {"name": "value"},
    {"name", "value"}
]