Using Workday RaaS to Extract Data Workday has a Reporting as a Service (RaaS) interface which allows you to export most data from Workday by creating a custom report within Workday then exposing it as a web service. The output can be various format...
I have a situation something like this: Employee IDEffective DateOffice11/1/2023San Francisco11/1/2024Oakland26/1/2023Sydney212/1/2023Tokyo I need to add an order column and end date of the previous record column. Can you please suggest any ways of ...
Hello,I need to write files into S3 by keeping file Size(<20mb) ,rather than giving number of records batch limit using pipeline execute. My input is dynamic sometimes 1k records write file >20mb , sometimes 10k records is <20mb. We also have batches...
How do I remove spaces from the output ?Output of this pipeline is [ {"lrs": ["Indiana","Alabama",""] }]
I have a two part question. I have to perform 3 queries to extract information from an application. I can put all 3 queries in the same REST Get snap. First question is…is this better or worse than using 3 separate REST Get snaps? Second question d...
Hello Community members,I have a scenario to discuss, if you can provide your assistanceI am receiving JSOnArray in pipeline which I am then splitting using Json splitter and those individual documents I am passing to child pipeline.In child pipeline...
Hi,I first do an SQL Server - Execute and get this weird {_snaptype_localdatetime: "..."} for the CreationDate and LastUpdate fields. Then, using a Mapper snap I do toString() to just get the date fields in string form. Then, I do a Group By on some ...
I have an input of 1000 Records coming in. I can only process 200 records at a time. How can I write a loop for this ?
| User | Count |
|---|---|
| 320 | |
| 210 | |
| 174 | |
| 147 | |
| 115 |
