topic How to build a Loop XPath Query that will return both with records and without records on the child element? in Talend Studio

How to build a Loop XPath Query that will return both with records and without records on the child element?

jerownimow — Mon, 11 Nov 2019 13:49:49 GMT

Hello Folks,
I have these JSON responses:

/*******1 - JSON without child elements on record node************/
{
    "totalSize": 0,
    "done": true,
    "records": []
}
/*******2 - JSON with child elements on record node************/
{
    "totalSize": 2,
    "done": true,
    "records": [
        {
            "attributes": {
                "type": "Transaction_History__c",
                "url": "/services/data/v45.0/sobjects/Transaction_History__c/987654321"
            },
            "Id": "987654321"
        },
        {
            "attributes": {
                "type": "Transaction_History__c",
                "url": "/services/data/v45.0/sobjects/Transaction_History__c/123456789"
            },
            "Id": "123456789"
        }
    ]
}

First configuration:
with XPath

For 1st response & 2nd response, respectively it has an output of:

withXPath

2nd configuration:

Blank Loop XPath

For 1st response & 2nd response, respectively it has an output of:
w/oXPath

Now, what I want to achieve are these output:
Expected Output
Can you please help me achieve this expected output? I believe it will be solved by correct mapping but I can't figure it out, have tried several combinations.
Thank you so much!

Re: How to build a Loop XPath Query that will return both with records and without records on the child element?

Anonymous — Fri, 22 Nov 2019 07:09:15 GMT

Read by xpath and set the loop xpath to /root/records/attributes, you should be able to have the expected output, see

Hope it helps you!

Regards

Shong

Re: How to build a Loop XPath Query that will return both with records and without records on the child element?

jerownimow — Tue, 03 Dec 2019 10:46:46 GMT

Thanks, Shong! Actually, that was an output of a tRESTClient.

What I did was to separate the pipes for both with different Xpath to get the desired output and just link both of their tHashOutputs.