Appian RPA update multiple get attributes in RPA Loop

Hello,

In your "Get Attribute" actions for "Get Status" and "Get Date", you need to specify the index of the CDT that is within the loop in the target field. For example, save into restaurant[fv!index].inspectionDate. The same issue will occur on the status.

Hi Cyrus,

I do not have the 'edit as expression' link for the target field. just the dropdowns available

One other option was to create a temporary pv! variable - itemStatus and itemInspectionDate and then use the 'Evaluate Expression' 

Inside the loop

Step 1:use get attribute to move the values to ItemStatus and itemInspectionDate like

Step 2:  Use evaluate expression at the end of the loop ..

a!update(pv!restaurant, fv!index, 'type!{urn:com:appian:types:RD}RD_ddrestaurantstosearch'(restaurantName: fv!item, restaurantStatus: pv!itemStatus, inspectionDate: pv!itemInspectionDate))

but looks like I need to work on the expression. It is not populating anything

Any suggestions ??

thanks

jaideep

Hi Jaideep,

With what you have, try appending the constructed CDT into pv!restaurant.

In RPA outputs for the evaluate expression select "Is appended to" the target pv restaurant.

In the expression itself, only have the constructor piece:
'type!{urn:com:appian:types:RD}RD_ddrestaurantstosearch'(restaurantName: fv!item, restaurantStatus: pv!itemStatus, inspectionDate: pv!itemInspectionDate))

Hi Cyrus, yes, but this is creating additional 2 more rows in the DB (while using appended) - though the status and date values are correct in the 2 new rows.

and 1 additional row (last row) when using (stored as)

both appended and stored as is adding more rows to the DB but what I need is to update the existing rows of the DB 

regards

jaideep

I have the same problem as well, I'm trying to update the status field of the current item in the loop after processing it, but it doesn't get saved in the variable. I can't use the target since it doesn't have an option to select an index or create an expression to point to the current index of the loop. I want to save the status first in the cdt variable so I can run the process model to update database just once after the loop, but I can't seem to find a workaround. Have you solved this problem?

finally was able to get this resolved

Apparently in the Evaluate Expression I had to move the restaurantid as well (which is the primary key) and all other fields..
a!update(
  data: pv!restaurant,
  index: fv!index,
  value: 'type!{urn:com:appian:types:RD}RD_ddrestaurantstosearch'(
    restaurantId: fv!item.restaurantId,
    restaurantName: fv!item.restaurantName,
    restaurantStatus: pv!itemStatus,
    inspectionDate: pv!itemInspectionDate)
  )

and target field as pv!restaurant variable

I just figured out the solution yesterday..i have posted it now above. Please try to learn it and see if it helps...if not we can discuss more.

thanks

jaideep

Hi Anwille, try changing the index to be fv!index in your a!update. What data type is fv!item? If it is a CDT, you may need to cast the values per Jaideep's answer above.

Hello, The fv!item is a multiple CDT. I’m trying to update the “requestStatus” field of the current item after each iteration of the loop. I tried casting values as well and used the item variable as the target save but it overrides the existing items. The workaround I did is using append instead of store and removing the 1st index of the CDT variable after appending. If there’s other optimal way of fixing this, I would appreciate.