Dear Team,
I am writing to request your assistance with an issue I am encountering while working with our mock SAP setup. Please find the details below, along with the attached Swagger file for your review.
---
1. Context
- We are using the attached Swagger file to create a mock SAP environment.
- I am using Nintex Workflow to retrieve data from this mock SAP via the defined API endpoints.
2. Issue Description
When I retrieve data for a specific object (e.g., object code OC"), the HTTP response returns a "value" field that contains two (2) items. However, instead of mapping each item into its corresponding column, the system displays the entire "value" array as a single combined string in one field.
Expected behaviour:
| Column | Data |
| Value 1 | Item 1 from the response |
| Value 2 | Item 2 from the response |
Actual behaviour:
| Column | Data |
| Value 1 | Item 1, Item 2 (both items combined) |
| Value 2 | Item 1, Item 2 (both items combined)|
In summary, the data is not being itemised or segregated into their respective columns.
3. Specific Questions / Requests
I would appreciate your guidance on the following two points:
Question 1 – Swagger File Review:
Could the attached Swagger file be the root cause of this issue? Specifically:
- Is the response schema defined in a way that prevents Nintex Workflow from parsing individual items within the "value" array?
- If yes, what specific changes should I make to the Swagger file to resolve this? Please indicate the exact section(s) and field(s) to be modified.
Question 2 – Data Segregation via Smart Object:
If the Swagger file is not the issue, is there a way to configure the Smart Object to itemise the data automatically? Specifically:
- Can the Smart Object be set up so that when the object code is "XXX", it reads the HTTP response data and maps each item in the "value" array to its corresponding column (i.e., Value 1 → Column "Value 1", Value 2 → Column "Value 2", and so on)?
- If yes, please advise on the step-by-step configuration required to achieve this.