Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Timezone in my integration — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Timezone in my integration

Received Response
3
Views
1
Comments

Hello all!

I've alredy created an integration that download a snapshot from Oracle FCC, to a sFTP folder successfully with a desired file name.

I added to the file name, the hour from 'startTime' but it cames with a different timezone, so I tried something like this xquerry:

string(fn:adjust-dateTime-to-timezone (xsd:dateTime(/nssrcmpr:schedule/nssrcmpr:startTime),xsd:dayTimeDuration(‘-PT3H‘)))

It gives an error on execution:

Error Summary: The <from> value is invalid. Xpath expression associated with <from> in copy assign activity is invalid.   There is an user error that results in missing element value(s) in the xpath query.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!