Returning Array of objects from response body via Integration HUB

[IronPotato]

Hi All,

I'm calling REST API via integrationHUB and when I'm parsing the body I'm unable to get proper output. Which should be var results = [{}], so array of objects.

Script

Here are my output variables (can anyone explain what is the Results_child variable that is created automaticaly?)

Everything works fine and I'm getting the data until I try to put it into object. So as soon as I wrap the data in curly bracers inside push method, the result array is empty object.

{
    "Results": [
        "Zengeon",
        0,
        0,
        "2019-01-18",
        "Vitamin Connection",
        0,
        0,
        "2020-02-20",
        "WARRIOR SPIRIT",
        0,
        0,
        "2021-01-01",
        "Half-Life: Absolute Zero",
        0,
        0,
        "2017-04-17"
    ]
}

Any help would be appreciated.

Thank you

Tomas

[Sandeep Rajput · Accepted solution]

@IronPotato Please refer to this page https://docs.servicenow.com/bundle/sandiego-application-development/page/administer/flow-designer/ta...

where starting from point #18 the entire step to create a complex object which is ultimately assigned to an array has been mentioned. 

Hope this helps.

[IronPotato]

Hi @Sandeep Rajput ,

thank you very much, I was able to create array of objects from the tutorial you've provided.

Much appreciated.

[Sandeep Rajput]

I am glad to know that it worked for you, my bad for the delayed response on the thread as I got caught up with the work and didn't find time on weekdays to respond to the thread.

[IronPotato]

@Sandeep Rajput , 

no problem at all :).

I'm facing another issue, so wanted to ask whether you know what might causing it:

I'm trying to use my action spoke in Data Sources app to basically map the data into my table, but when I'm trying to look for the reference it's empty

and as you can see here. Action is active, accessible to all apps and published

Thank you.

[Sandeep Rajput]

@IronPotato I have checked the reference qualifier of Request action button and found that apart from a published action, it also looks for Action Template field and it should be of type Data source template.

Your action might not have this Action Template type hence it is not showing up in the list.