Update a service offering when the related service is updated with a transform map

[Patrick Cavanau]

Hello Community, 

I have made a transform map that updates services from an excel sheet. We match the service name and then update the owned by and department fields. I was wondering if it would be possible to then update the same fields on the service offerings that have that service as the parent using the same transform map. 

Thank you for any advice! 

[SteveMacWWT]

@Patrick Cavanau Is this something that needs to happen even if the Bus Svc is manually updated?

If so I would recommend an onAfter Business Rule on the Business Service. This way you don't need to explicitly handle it in the Transform.

If it is only needed for these imports, it might be easier to set up a 2nd transform just for the Service Offering table. 

[Patrick Cavanau]

@SteveMacWWT This will only be updated via a transform map and data load. 

I actually have tried to have a 2nd transform map but the issue with this is that we are given only service names as the reference in the data load so they will skip over updating the service if it has more than one related service offering because I have to use the parent field as the coalesce. 

Do you have any ideas on how to change that from happening?

[Patrick Cavanau]

Currently, this is the code that I have for this, but it is not updating the related services as expected.