Infor Api Flow. Problem since last weekend update (only 1 product returned instead of 2)

Nathalie Abel · 2025-03-19T17:42:24+00:00

There was an error rendering this rich post.

I have an Infor Api Flow with a JQTransform. Before the response was returning 2 products. since this weekend, only 1 is returned. I can't find why. ex:

Before (2 products returned, in my request: prod ABC and prod XYZ):

{

"resultList": [

{

"prod": "ABC",

"netavail": 500,

"price": 59.10,

"List_price": 200.00

{

"prod": "XYZ",

"netavail": 500,

"price": 48.55,

"List_price": 135.83

}

]

}

Since this weekend: (only 1 product returned, in my request: prod ABC and prod XYZ)

{

"result": {

"prod": "ABC",

"netavail": 500,

"price": 59.1,

"List_price": 200.00

}

Here is my JQTransform:

.response.tOemultprcoutV4["t-oemultprcoutV4"][] | {prod: .prod, price: .price, List_price: .listprice, netavail:.netavail} | .netavail |= if .> 500 then 500 else .
end

Find more posts tagged with

Accepted answers

Brandon Watson

I am also getting only one response with your jq statement. I was able to get two responses with the below.

.response.tOemultprcoutV4["t-oemultprcoutV4"] | map( {prod, price, List_price: .listprice, netavail: (if .netavail > 500 then 500 else .netavail end)})

Brandon Watson

You can change that to use the slice notation.

.response.tFieldlist["t-fieldlist"][:2]

Brandon Watson

Depends if you need all of the values:

.response.tFieldlist["t-fieldlist"]
| map(select(.fieldName == "orderno" or .fieldName == "linelevel-botype"))

Or if you want to create a new response:
.response.tFieldlist["t-fieldlist"]
| map(select(.fieldName == "orderno" or .fieldName == "linelevel-botype"))
| reduce .[] as $item ({}; .[$item.fieldName] = $item.fieldValue)

Nathalie Abel

Brandon thks it works great

Brandon Watson

Something like the below should work for both of those combined.

{
orderInfo: (
.response.tFieldlist["t-fieldlist"]
| map(select(.fieldName == "invoicedt" or .fieldName == "orderno"))
| reduce .[] as $item ({}; .[$item.fieldName] = $item.fieldValue)
),
lineItems: (
.response.tOelineitemV3["t-oelineitemV3"] // []
| map({prod: .prod, description: .desc1, qtyOrd, qtyShip, price})
)
}

All comments

Brandon Watson

Nathalie Abel

wow thks Brandon. do you know what have changed in the update ? I have the same problem with .response.tFieldlist["t-fieldlist"][0,1] for another api call. What should I use instead ?

Brandon Watson

You can change that to use the slice notation.

.response.tFieldlist["t-fieldlist"][:2]

Nathalie Abel

ok and here if I need fieldName orderno and fieldName linelevel-botype only:

{
"response": {
"cErrorMessage": "",
"tFieldlist": {
"t-fieldlist": [
{
"fieldName": "orderno",
"fieldValue": "11611229",
"seqNo": 1
},
{
"fieldName": "linelevel-returnfl",
"fieldValue": "no",
"seqNo": 1
},
{
"fieldName": "linelevel-canceldt",
"fieldValue": "",
"seqNo": 1
},
{
"fieldName": "linelevel-botype",
"fieldValue": "y",
"seqNo": 1
},

Brandon Watson

Nathalie Abel

Brandon thks it works great

Nathalie Abel

Brandson, last question:

I wrote this but in the same api I need what I wrote in Bold. how can I use both ?

.response.tFieldlist["t-fieldlist"]
| map(select(.fieldName == "invoicedt" or .fieldName == "orderno"))
| reduce .[] as $item ({}; .[$item.fieldName] = $item.fieldValue)

.response.tOelineitemV3["t-oelineitemV3"] ({prod: .prod, description: .desc1, qtyOrd,qtyShip,price})

Nathalie Abel

My customer wants to call my api and retreive a pdf invoice. Is that possible ?