Community - About pask

pask · ‎02-16-2021

Hi, we are experiencing errors in rerunning failed custom object record create tasks in Zuora Workflow. When we re-execute we got all custom object records duplicated. E.g. We have a callout with 500 total insert, Task fails on 2 records only. When we resubmit the request Zuora will write once again all 500 records. so in custom object we have 998 records instead of 500. Could you implement a partial retry in order to avoid this problem? Thanks in advace Pasquale

pask · ‎02-11-2021

Hi, we would like an enhanced JSONTransform::JSONata workflow task version with variable bindings like JSONata exerciser. Thanks Pasquale

pask · ‎01-25-2021

Hi @shakir-karim I've opened a Zuora Support Ticket for my last request * Regards Pasquale * removed support ticket url

pask · ‎01-25-2021

Hi @shakir-karim , is it possible to enable it on my training test sandbox? it is apisandbox.zuora.com. TenantID: * Thanks in advance Pasquale * removed

pask · ‎01-25-2021

Hi, we tested today in our EU Sandbox with Tenant ID: 2000247 in entity Enel X UAT Spain B2C (8adc8f996a06ca08016a0c704a45025d). All describe statement that you shared are not working. If we perform show tables mentioned tables are not showed. Thanks in advance Pasquale

pask · ‎01-23-2021

Hi, could I suggest to create a checkbox in each workflow task that enables us to manipulate dynamically task JSON request body (for example In workflow json each task have its static structure, we would like a way to change this structure at runtime) ? Sometimes we need to dynamically select files and we need a way to pass them dynamically to MergeCSV task overriding the static pre-configured ones. Thanks in advance Pasquale

pask · ‎01-23-2021

Hi, we need to filter credit memo by SourceId in order to get credit memos from billrun using sync REST API. It could be an enhancement of the already existing get Credit Memos API. Thanks in advance Pasquale

pask · ‎01-23-2021

Hi, It would be very useful to have a REST API to Update a workflow. In particular we need to update workflow name and scheduled checkbox. But in general it would be nice to update the whole workflow structure. Thanks in advance Pasquale

pask · ‎01-23-2021

Hi, we are receiving a lot of workflow notifications related to async task exhausted. We used DQ everywhere in the system because it is the only functionality in Zuora that enables us to do join and complex SQL queries. It also enables us to reduce task number. For online flows starting from notifications for example we should substitute DQ with a chaining of direct sync query/REST APIs and rearranging data using JSONata simulating all joins (to be honest sometimes we do not have a direct rest api to retrieve the same data) but in this way we have to mantain and fix two version of the same workflow a massive one using DQ and a non massive using sync API. What I am trying to suggest is: Creating a wrapper that receives in input a DQ and transforms in some way it in a sync call without changing our SQL query. In this case we can write our query once and we mantain/fix our logic once and we will have the possibility to have a workflow task/REST API that automatically switches to sync mode based on a dynamic selectable checkbox. Thanks in advance Pasquale

pask · ‎01-23-2021

Hi, we noticed that using Liquid tester we have to use Chrome inspect element in order to copy the output. Could we receive an enhancemt that consists in creating a dedicated area in which all output that we have in liquid Tester could be copied in a user friendly way? Also a tab in which we could see all variables that we define in the tester could help. A tab containing all functions/filters that we can use in liquid with a short description related to input/output. Thanks in advance Pasquale

pask · ‎01-23-2021

Hi, we are receiving a lot of workflow notifications related to async task exhausted. We used DQ everywhere in the system because it is the only functionality in Zuora that enables us to do join and complex SQL queries. It also enables us to reduce task number. For online flows starting from notifications for example we should substitute DQ with a chaining of direct sync query/REST APIs and rearranging data using JSONata simulating all joins (to be honest sometimes we do not have a direct rest api to retrieve the same data) but in this way we have to mantain and fix two version of the same workflow a massive one using DQ and a non massive using sync API. What I am trying to suggest is: Creating a wrapper that receives in input a DQ and transforms in some way it in a sync call without changing our SQL query. In this case we can write our query once and we mantain/fix our logic once and we will have the possibility to have a workflow task/REST API that automatically switches to sync mode based on a dynamic selectable checkbox. Thanks in advance Pasquale

pask · ‎01-23-2021

Hi,great, thanks for this enhancement. It will be very useful in creating workflow that automatically re-executes failed tasks without opening them manually and also to derive reports in general. I'll test it in these days. Regards Pasquale

pask · ‎12-14-2020

Hi all, we are trying to create a dynamic csv merge workflow from SFTP folder. We created a workflow that receives a JSON Filelist in input with filenames to download. If we put dl and merge task in sequential way: Merge task is able to "see" all files to merge. We think that is quite not optimized to create a workflow with 1000 static download task to cover the worst case. We tried to create a loop without iterate task in order to return to DL task recursively but for each iteration we got the previous file overridden (so we added some logic to backup files strucure) and final merge task will see only one file. Is there a way to dynamically set filenames in merge task? Or something to call directly workflow task via callout in order to set some liquid code to dynamically set filenames? Any other idea to develop this dynamic non sequential merge csv workflow? Note: We would like to use only one merge task without merging in sequential way (two files at time e.g: merge first and second once obtained third file get merged url and use it to redownload previous merged file and merge it with the third etc. We already done in this way and it is very slow. To merge 208 files it will task 8 hours) Thanks in advance Pasquale

pask · ‎11-23-2020

Hi, we are migrating Invoice,CreditMemo and Payments from Legacy accounting system in an opened accounting period in Zuora. We would like to exclude all related transactions from Journal run. Is there a simple way to accomplish this task? We have almost finished all slots for segment + segmentation rules. We are looking for a non custom way. Of course we could create a segment on each transaction and populate custom filed accordingly and using a workflow we can exclude journal entries from final report. Thanks in advance Pasquale

pask · ‎08-25-2020

Hi, we are experiencing problems in massive payment creation with invoice settlement enabled. We are using MPU (Massive Payment Upload) functionality but this feature doesn't include custom field and they are necessary for almost every flow that we have. We need massive APIs also for other objects CreditMemo,DebitMemo,Refund but with lower priority. Is it possible to add it in roadmap? Thanks in advance Pasquale

pask · ‎06-24-2020

Hi, Yes it will be very useful. As for the problem you mentioned. In our project we trigger the workflow from system event by using workflow name instead of workflow ID. Name will not change we suggest to use workflow names without spaces. If wf name has spaces you should convert in url format. We need this feature in order to rename automatically older versions of the same wf.

pask · ‎06-03-2020

Hi, we are getting error in Zuora Workflow when we try to download a file from sftp using * as search string when no file is found. Is there a way to get a checkbox in order to not trigger the error? it will be better to let the user decide to stop the task when no file is found. Thanks in advance Pasquale

pask · ‎05-20-2020

@pask wrote: Hi, we have some flows that uses AQUA API to get data. It would be useful to enable AQUA query to support Custom Objects, in order to leave the logic unchaged in quering custom objects and Standard Objects pre-joined. Thanks in advance. I totally agree with you, no way to create report and query Custom Objects without using Data Query.

pask · ‎05-07-2020

Hi, it could be very useful to have the possibility to set sequence set ID directly on invoice, creditmemo, debit memo, payment, refund. The main problem is that now sequence set is at account level but we need to set different numbering under the same account for some categories of invoices for example and what we are doing is basically override, post, restore original sequence, this could generate wrong sequence for other documents belonging to the same account. Thanks in advance Pasquale

pask · ‎05-07-2020

Hi, could you enable Zuora Workflow File::CreateCsv in order to support constant values in csv creation? For example we would like to create a csv with an additional column that is a constant value. It could also be useful to make the task non positional and add the ability to put some liquid code and multiple fields concatenation in order to extend data export functionality. Thanks in advance

pask · ‎05-07-2020

Hi. We need to produce a positional txt file. We would like to use Data Query Workflow Task. Could we find a way to eliminate header from output csv? Is the only problem we have in this implementation, maybe a checkbox in data query task. Thanks in advance Pasquale

pask · ‎02-24-2020

Hi, we are developing a tool for importing and exporting workflows using Official Zuora REST API. We used: 1) Get Workflows: to get all workflow Ids 2) Export a workflow: to export all workflows 3) Import a workflow: to import workflows We are using workflow name as key to communicate to an external system. So when we develop a new workflow version and we need to update the existing one there is no api that automatically updates the older version. We need to rename manually the previous version and then import the newer one. Can we request an official api to rename a workflow? Thanks in advance

pask · ‎11-03-2019

Hi, I don't know if there is a feature to directly login into a specified entity. Using this link https://sandbox.eu.zuora.com/apps/newlogin.do?method=login Zuora will automatically login into main entity. Thanks in advance.

pask · ‎10-16-2019

Hi, we have some flows that uses AQUA API to get data. It would be useful to enable AQUA query to support Custom Objects, in order to leave the logic unchaged in quering custom objects and Standard Objects pre-joined. Thanks in advance.

pask · ‎10-10-2019

Hi, we would like to suggest a new functionality, similar to invoice subscription separately but applied to Usages. We need to Bill Usages Separately under the same account so that when performing a bill run for this account if we have n pending usage we will get n Invoices. Or a similar functionality could be the possibility to generate an invoice for specific subscriptions or specific usages. Thanks in advance. Pasquale

pask · ‎10-08-2019

Hi, A tool for importing and exporting workflows. This tool should: 1) Export All Workflows or a Subset of Workflows 2) Import a Subset of Workflows. Note 1: when importing a workflow having the name matching with a preexisting one it should autorename the old one in order to track the old workflow history and import the new one. Note 2: We usually use Workflow Name instead of the id for portability reasons and if we try to import a workflow using the same name all callout goes KO. Note 3: We tried to develop a tool in java but we can't perform workflow name update using API we can only perform get all workflow and create workflow task. Thanks in advance. Pasquale

pask · ‎10-08-2019

In order to perform a fast and correct bug fix we need to be able to search inside all workflow history for a specific key, contained for example in the input parameters or inside any block in task execution. Thanks in advance Pasquale

pask · ‎10-08-2019

Hi, in some cases there is the need to have a shared memory between on start and on finish tasks inside zuora workflow. For example if we do some operation on a set of object interating over them in the start task and we want using on finish to do a specific operations on this data that could be an update or whatever we would like to avoid to query the data again. Thanks in advance.

pask · ‎10-08-2019

Hi, I would suggest this idea that I think it would be useful in order to satisfy a lot of business requirements: We would like to sync Custom Objects from Zuora to Salesforce using Zuora 360. Thanks in advance.

pask · ‎10-08-2019

Hi, I would like to suggest this idea: When we define a custom object with specific relationship for example AccountId to link the account or InvoiceId to link an invoice it would be very useful to show that objects in the relatated object Layout. Hope that this idea could be useful and appreciate

Happy Business Starts Here