API Connection Point - IFS Service Ingestion to Datalake - Manual Mapping

I have created a workflow which uses the IFS Service API GET ifsservice/usermgt/v2/admin/users which gets IFS user data. I want to ingest some of this data into the Datalake however whilst I have managed to do this, it only ingests a single record and not the entire 220.

Response from API

{
"response": {
"startIndex": 1,
"count": 1000,
"totalResults": 220,
"userlist": [
{
"id": "12345-67890-98765-43210",
"userName": "dummy.user@infor .com",
"name": {
"familyName": "User",
"givenName": "Dummy"
},
"emails": [
{
"value": "dummy.user@infor.com",
"type": "work",
"primary": true
}
],
"upn": "dummy.user@infor .com",
"lastLogon": "2022-12-07T08:30:08.1570000Z",
"status": "disabled",
"isServiceUser": false
},
{
"id": "12345-67890-98765-43211",
"userName": "john.doe@infor .com",
"name": {
"familyName": "John",
"givenName": "Doe"
},
"emails": [
{
"value": "john.doe@infor .com",
"type": "work",
"primary": true
}
],

etc etc

Manual Mapping

{
"id": {"IonApiRef": "$..id"},
"userName": {"IonApiRef": "$..userName"},
"upn": {"IonApiRef":"$..upn"},
"status":{"IonApiRef": "$..status"}
}

Output

{
"id": "12345-67890-98765-43210",
"userName": "dummy.user@infor .com",
"upn": "dummy.user@infor .com",
"status": "disabled"
}

How do I get the output to utilise all of the users and not just the first returned record?

Any help very much appreciated

Thanks

Jon

Find more posts tagged with

datalake input

Data Lake

ION

Accepted answers

All comments

Jon Matthews

In additional to this I attempted to import the entire response into the Datalake however occurs errors as some of the fields (e.g name & emails) are nested objects. I attempted to change the object schema to reflect this however the API still responses with unwanted fields. I only need the Status of the accounts and perhaps LastLogin

Danil Klemeshov

Hi Jon,

Could you provide more details about your use case and the reason you need to use Workflows?

ION Workflows are primarily designed to involve humans in the process through tasks, notifications, and similar actions—not for direct data manipulation. In your scenario, working with a multilevel JSON might be better suited for other options.

Here’s an excerpt from our documentation:
"When using a simple path that points to an element that is repeating, or is part of a structure that is repeating, the first occurrence is retrieved by default. To extract a different occurrence, you can use index and filter expressions."
https://docs.infor.com/inforos/latest/en-us/useradminlib_cloud/default.html?helpcontent=iondeskceug/apj1492004375372.html .

Have you considered using a Data Flow or an API Flow instead?

Jon Matthews

Sorry for the confusion, I am using a data flow not a workflow. I have managed to solve this by using a python script to convert the API output into a valid ND-JSON for consumption to the datalake.

rnsimmons

I want to do the same, but to save the output to an sFTP site.

On the possibility that I may have a similar issue with retrieving just the first record, would you be willing to share your Python script?

Copyright © 2025 Infor. All rights reserved.