addProperty - adding multiple properties at one time...syntax?

(0) Share

Report

Posted on by sasrsc

678

In a select action I am doing...

addProperty(item(),'ProjectStatusId',xpath(outputs('XMLComments'),concat('//Array[ProjectId/text()="', item()['ReportId'],'"]/StatusId/text()'))?[0])

Right after I am doing another select to append a different property using the same xpath query but a different variable. The previous one appended "StatusId" and this one appends "PercentComplete". They are both referencing the same object where ProjectId value=item() ReportId.

addProperty(item(),'PercentComplete',xpath(outputs('XMLComments'),concat('//Array[ProjectId/text()="', item()['ReportId'],'"]/PercentComplete/text()'))?[0])

Can I combine these into one select ... I don't want to use the standard select where you map each property because I have alot of them - I only care about appending/adding these 2 properties.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Heartholme 1,278 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

HI @sasrsc,

Was doing exactly what you were doing, and thereby had the exact same issue. Unfortuneately, I wasn't able to solve this in one action.

Solved it like this, with 2 arrays, which still have very good performance, but dosen't seem as smooth I guess.

{ If my post answered your question, please Accept it as a solution ✔ }
{ This will in turn help others find solutions to similar questions }

Best Regards
Heartholme

Was this reply helpful? Yes No
Heartholme 1,278 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

By the way, @sasrsc.

I guess you watched @Paulie78 video on this as well. It might be that he can shed some light on if it's possible to get multiple properties in the same select.

Br

Heartholme

Was this reply helpful? Yes No
sasrsc 678 on at

Like (1)

Report
Copy link

Link copied!

Yep, @Paulie78 provided the inspiration. I'd never done anything with xpath prior ...

Was this reply helpful? Yes No
sree813 77 on at

Like (1)

Report
Copy link

Link copied!

Hey @sasrsc, I was able to do it in my solution. Here are my two addproperty values which is converted in to single expression.

addProperty(item(), 'fine_band', xpath(xml(outputs('XML')), concat('//Array[transaction_id/text()="', item()?['transaction_id'], '"]/fine_band/text()'))?[0])

addProperty(item(), 'transaction_reference', xpath(xml(outputs('XML')), concat('//Array[transaction_id/text()="', item()?['transaction_id'], '"]/transaction_reference/text()'))?[0])

Single Expression:

addProperty(addProperty(item(),'fine_band',xpath(xml(outputs('XML')), concat('//Array[transaction_id/text()="', item()?['transaction_id'], '"]/fine_band/text()'))?[0]),'transaction_reference', xpath(xml(outputs('XML')), concat('//Array[transaction_id/text()="', item()?['transaction_id'], '"]/transaction_reference/text()'))?[0])

Hope this helps you.
Thanks.

Was this reply helpful? Yes No