retrieve attachmentId from payload response

[pedrocosta]

Hi

I have posted an attachment into SuccessFactors and I receive the below response:

now, to assign the attachment to a custom Mdf object, I would like to store the attachmentId as a property in a content modifier, however, the xml response I receive is actually unworkable, mostly because the highest level node has the namespacing with all those special characters, so navigation is not possible from that point

also, the field attachmentId is actually as below as well (with special characters)

<d:attachmentId m:type="Edm.Int64">2414</d:attachmentId>

how can I achieve this?

any help would be really appreciated

thank you

[MortenWittrock]

Hi Pedro

It's not really clear what you mean by special characters. Also, could you please post the raw XML using the "Insert Code" button instead of a screenshot. That makes it a lot easier to verify a solution.

Regards,

Morten

[pedrocosta]

Hi Morten, thank you for the quick reply

please see below the code, the problem I have is that when trying to set it as a property in the content modifier, it throws errors because, for example, the node <d:attachmentId> has that bit "m:type="Edm.Int64" on it.

I get something similar when trying to do XSLT (maybe either I am doing it wrong or is the wrong approach to even go for the XSLT route)

<?xml version="1.0" encoding="UTF-8"?>
<entry xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xml:base="https://api2.successfactors.eu/odata/v2/">
   <id>https://api2.successfactors.eu/odata/v2/Attachment(2414L)</id>
   <title type="text" />
   <updated>2023-03-17T03:25:47Z</updated>
   <author>
      <name />
   </author>
   <link rel="edit" title="Attachment" href="Attachment(2414L)" />
   <category term="SFOData.Attachment" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
   <content type="application/xml">
      <m:properties>
         <d:fileName>600024.pdf</d:fileName>
         <d:module>GENERIC_OBJECT</d:module>
         <d:userId>600024</d:userId>
         <d:viewable m:type="Edm.Boolean">true</d:viewable>
         <d:fileContent m:type="Edm.Binary">inbodw==</d:fileContent>
         <d:attachmentId m:type="Edm.Int64">2414</d:attachmentId>
      </m:properties>
   </content>
</entry>

[MortenWittrock · Accepted solution]

Hi Pedro

There's nothing wrong with your XML. And yes, your issue probably has to do with namespaces. In order to use them in an XPath expression, you need to declare them first. Go to your iflow's Runtime Configuration tab (click the iflow canvas, i.e. the background) and add the following to the Namespace Mapping field:

xmlns:n=http://www.w3.org/2005/Atom;xmlns:m=http://schemas.microsoft.com/ado/2007/08/dataservices/metadata;xmlns:d=http://schemas.microsoft.com/ado/2007/08/dataservices

It should look like this when you're done:

Now create a property with Source Type set to XPath and the value set to:

/n:entry/n:content/m:properties/d:attachmentId

Like this:

After this Content Modifier step, the property contains the correct attachment ID.

Regards,

Morten

[pedrocosta · Accepted solution]

Hi, you are an absolute star as always, the solution you provided indeed worked and it made me feel quite silly as I had tried a similar approach, but I had the content modifier syntax written incorrectly, so I dismissed it completely.

thank you very much for your help

Best Regards

Pedro Costa

[MortenWittrock · Accepted solution]

Thank you for the kind words, pedro290883. Glad to hear you got it working.

Regards,

Morten