hi there,

I am new to API connect, I am using OPEN API 2.0,  I appreciate if you can help me to resolve one problem.

I am getting an issue with an array in the request message. 

When I call my BAW API via API connect , it duplicates the array elements. but when I run the API directly through BAW it gives expected results.

To elaborate my question, for example, I have a Products object in my request message, and within this object ,I have an array of type Product, Inline Schema representation of this object in API designer is:

"Products": {
              "type": "object",
              "properties": {
                "Product": {
                  "type": "array",
                  "items": {
                    "type": "object",
                    "properties": {
                      "Product_Business_Unit": {
                        "type": "string",
                        "name": "Product_Business_Unit"
                      },
                      "Product_Group__c": {
                        "type": "string",
                        "name": "Product_Group__c"
                      }
                    }
                  },
                  "name": "Product"
                }
              },
              "name": "Products"
            },

and Source representation is:

 set: parameters.initiateKYCEngineRq.party_requirements.Products

              from: initiateKYCRequest.party_requirements.Products

            - create: >-

                parameters.initiateKYCEngineRq.party_requirements.Products.Product

              foreach: initiateKYCRequest.party_requirements.Products.Product

              from: initiateKYCRequest.party_requirements.Products.Product

              actions:

                - set: $item

                  from: $item

                - set: Product_Business_Unit

                  from: Product_Business_Unit

                - set: Product_Group__c

                  from: Product_Group__c

I am sending the array in the request message  with one element

 "Products": {  "Product": [

                {

                    "Product_Business_Unit": "c",

                    "Product_Group__c": ""

                }

            ]},

but  it gets duplicated when it passes through API gateway(map policy) :

  "Products": {

            "Product": [

                {

                    "Product_Group__c": "",

                    "Product_Business_Unit": "c"

                },

                {

                    "Product_Group__c": "",

                    "Product_Business_Unit": "c"

                }

            ]

        }

    },

Please advice what is causing this duplication of array elements. it is doing the same for all other arrays in the request message.

I would appreciate your help and guidance here.

Thanks and Regards,

Monica

Hi Monica,
When you wire an array to an array in the map policy, it generates a create action in the map actions.  The create action is effectively an "add this mapping to any already create array output items".  For example, you could have two separate arrays in your input, and both could be wired to the same output array.  In this case, the first create would generate 1..n output array elements, and the second create would add to those with the 1.n array elements from the 2nd input.  So what's happening in your case.  You have two actions in your map policy.

            - set: parameters.initiateKYCEngineRq.party_requirements.Products
              from: initiateKYCRequest.party_requirements.Products
            - create: >-
                parameters.initiateKYCEngineRq.party_requirements.Products.Product
              foreach: initiateKYCRequest.party_requirements.Products.Product
              from: initiateKYCRequest.party_requirements.Products.Product
              actions:
                - set: $item
                  from: $item
                - set: Product_Business_Unit
                  from: Product_Business_Unit
                - set: Product_Group__c
                  from: Product_Group__c

The set is effectively copying your input Products object, including the child Product array, to the same structure in your output object.  Now your output has one product element.  The create then does the specific mapping for the array, but it is taking from the same input array and mapping to the same output array, which would be why you're seeing the duplicate.

So in your case since the mapping is so simple, you can remove one or the other action.   If your output schema is different, for example, the input array element objects use different names than the output array element objects, then the set action would be putting into your output objects with an incorrect output name and you'd need to eliminate that one, but in your case where everything appears to be identical between the input and output schemas, removing either action should  do the trick.

Regards,
Steve

Thanks Steve for your suggestion.

 I removed all the mappings and tried keeping

only one set of action and it did the trick.

To be precise, I kept mapping at the field level instead of array level.

Thanks once again to help me out. 😀

            - set: parameters.initiateKYCEngineRq.party_requirements.Products              from: initiateKYCRequest.party_requirements.Products            - create: >-                parameters.initiateKYCEngineRq.party_requirements.Products.Product              foreach: initiateKYCRequest.party_requirements.Products.Product              from: initiateKYCRequest.party_requirements.Products.Product              actions:                - set: $item                  from: $item                - set: Product_Business_Unit                  from: Product_Business_Unit                - set: Product_Group__c                  from: Product_Group__c