About yamasaki1ma

yamasaki1ma · ‎03-24-2018

Hi @Emmanuel (I regarded the date format you indicated as DD/MM/YYYY) I was surprised at this result. Why do you get billing until the 5th of May??? I tried to reproduce with the settings you indicated. Settings: Account.BillCycleDay: 6th Subscription.InitialTerm: 1 year Subscription.TermStartDate: 10/04/2018 Subscription.CED/SAD/CAD: 06/03/2018 RatePlanCharge.BillingPeriod: 1 year RatePlanCharge.BillCycleType: DefaultFromCustomer RatePlanCharge.BillingPeriodAlignment: AlignToTermStart I confirmed that your results will be reproduced! I interpreted this as follows: Since CED/SAD/CAD was set to 06/03/2018, the service period starts from 06/03/2018. BillCycleDay of Account was set to 6th and BillCycleType of Charge was set to DefaultFromCustomer, so Charge's BillCycleDay was set 6th of every month. TermStartDate is 10/04/2018, so "next Bill Cycle Day" will be 6th May of 2018. The end of the service period is one day before the billing day. --> Billing occurred during the period from 06/03/2018 to 05/05/2018 I prepared a figure for explanation: --- Because TermStartDate is later than 6th April of 2018, it seems that next Bill Cycle Day will be May. For example, if you set TermStartDate to 2018/04/06 (or earlier date), the first service period changes to "06/03/2018 to 05/04/2018": * Since we set 10/04/2018 as the Target Date of Bill Run, Billing of secound Service Period (06/04/2018 to 05/04/2019) have also occurred.

yamasaki1ma · ‎02-27-2018

I point out that this is already implemented Idea. I understand that the function described in the Post below is an implementation of this Idea: What is the function of the feature "Do not process usage charges without usage records" I notice that a similar Idea is below: Suppressing Posting $0 Invoices with Usage

yamasaki1ma · ‎02-22-2018

> the Result in Notifications states OK Oh, It's too much for me. Please contact Global Support. I am sorry I can not help you...

yamasaki1ma · ‎02-22-2018

@bolaurent I am always helped by your Post. I recently started using Python. I will try using the code you uploaded to Github!

yamasaki1ma · ‎02-16-2018

Hi @csullivan The function to post Invoice by e-mail is one of "Notification". By viewing the history of Notification you can check whether the Invoice was delivered or not. There are two ways to see the history of Notification: Method 1. How to view the history of all Notifications: Billing Setting -> Setup Profiles, Notifications and Email Templates -> Notification History Method 2. How to view the history of Notification for a specific Account: Customer Accounts -> (any Account) -> Notification History Section ... at the bottom of the page of Account

yamasaki1ma · ‎02-14-2018

Hi @avi91, @AmyLy I once responded to a similar question: https://community.zuora.com/t5/Subscriptions/How-to-activate-a-pending-acceptance-subscription-in-SOAP-REST/m-p/21703#M707 In the link above, I explain how to set the date in ContractAcceptanceDate, but the same operation is possible when setting the date in ServiceActivationDate. That is, ServiceActivationDate can be updated using the following Endpoint and Request: [PUT] https://rest.apisandbox.zuora.com/v1/object/subscription/{Target Subscription's Id} (For Example: https://rest.apisandbox.zuora.com/v1/object/subscription/2c92c0f86103a992016103fe5fd175aa) Request Body: { "ServiceActivationDate": "2018-08-15" } Note: The field name of Key is ServiceActivationDate. Although it may be possible by the method AmyLy mentioned, it is easier to use this Endpoint. ---- Additional Notes for @avi91 This is not an essential indication. But I tell you. You are using "https://apisandbox-api.zuora.com/rest/" as an endpoint. No problem. This Base URL works correctly. But, in fact, this Base URL is legacy one. Currently, it is better to use "https://rest.apisandbox.zuora.com/" as described in the REST API Reference. https://www.zuora.com/developer/api-reference/#section/Introduction/Endpoints

yamasaki1ma · ‎02-12-2018

Hi @Vojtek Yes, there is a way to do what you want. In conclusion, you should use the following Endpoint and request: (I assume that the "ERP identifiers" of RatePlanCharge is the Custom field of RatePlanCharge that you created) [POST] https://rest.apisandbox.zuora.com/v1/action/update Request body: { "objects": [ { "Id": "2c92c0f96103b59801610d563e84296a", "your_customfield__c": "abcdefg" } ], "type": "RatePlanCharge" } Note: - For "Id", set the ID of RatePlanCharge (not Subscription). - Replace "your_customfield__c" with the API name of the Custom Field of your Sandbox. Please tell me whether the results you performed match the results you want.

yamasaki1ma · ‎02-05-2018

Hi @bozzetti The URL is correct and other requests are successful, ok, from another point of view I ask you: Running Bill-Run via API is one of the functions called "Limited Availability". In order to use the function of Limited Availability, it is necessary to ask Global Support. https://www.zuora.com/developer/api-reference/#operation/Object_POSTBillRun > Note: This feature is in Limited Availability. If you wish to have access to the feature, submit a request at Zuora Global Support. Have you asked Global Support?

yamasaki1ma · ‎02-05-2018

@bolaurent I am happy that I can help you. I also checked that I can call POST to /object/ProductRatePlanCharge. I did not know ...

yamasaki1ma · ‎02-04-2018

Hi @bolaurent This Endpoint (/object/ProductRatePlanCharge) does not seem to be accepting "POST" requests. Actually, only the example of "GET" and "DELETE" are listed in the Reference. I once created ProductRatePlanCharge (and Tier) with /action/create. Hopefully this will be an alternative. https://community.zuora.com/t5/API/How-Do-you-Create-a-Product-Rate-Plan-Rate-Charge-Tiers-via-REST/m-p/18921#M1052

yamasaki1ma · ‎01-17-2018

I answered the question by @chdavid in the next Post: https://community.zuora.com/t5/Subscriptions/How-to-activate-a-pending-acceptance-subscription-in-SOAP-REST/m-p/21703#M707

yamasaki1ma · ‎01-17-2018

Hi @chdavid If you use the REST API, you can activate a Subscription that Status is "Pending Acceptance" by one of the following two Endpoints. Yes, anyway, simply set the date and update Subscription, the Status will be automatically changed to "Active". Endpoint 1: "CRUD: Update Subscription" [PUT] https://rest.apisandbox.zuora.com/v1/object/subscription/{Target Subscription's Id} (For Example: https://rest.apisandbox.zuora.com/v1/object/subscription/2c92c0f86103a992016103fe5fd175aa) If you use this Endpoint, the Body of the request should be as follows (assuming your customer is ready for 2018/02/01): { "ContractAcceptanceDate": "2018-02-01" } Endpoint 2: "Update" [POST] https://rest.apisandbox.zuora.com/v1/action/update If you use this Endpoint, the Body of the request should be as follows (assuming your customer is ready for 2018/02/01): { "objects": [ { "Id": "2c92c0f86103a992016103fe5fd175aa", "ContractAcceptanceDate": "2018-02-01" } ], "type": "Subscription" } Note 1: When using UI, to change Status from "Pending Acceptance" to "Active", we enter the date in "Customer Acceptance Date". On the other hand, when using API, "ContractAcceptanceDate" is used instead of "Customer Acceptance Date" field. (I do not know this reason) Note 2: When "Update" is used, up to 50 Subscriptions can be activated with per call. When activating multiple subscriptions, you write in the "objects" array as follows: { "objects": [ { "Id": "2c92c0f86103a992016103fe5fd175aa", "ContractAcceptanceDate": "2018-02-01" }, { "Id": "2c92c0f86103a98e0161040ebf5a0af9", "ContractAcceptanceDate": "2018-02-01" } ], "type": "Subscription" } When "CRUD: Update Subscription" is used, only one subscription can be activated with per call. However, as you can see from the example above, the Body of the Request is simple. Note 3: I've only used the REST API, so I do not know much about the SOAP API. But since you can also use "Update" with SOAP API, you can activate Subscription in the same way as above example.

yamasaki1ma · ‎01-12-2018

I want to get opinions from everyone who read this Post. Hi all, I'm Japanese. From the custom of Japan, I'm feeling something strange with Zuora's Subscription End Date. For example, the Subscription End Date of Subscription with Current Term of 1 year and Subscription Start Date of 2017/01/01 will be displayed as 2018/01/01 in Zuora. I know that when the Subscription End Date is displayed as 2018/01/01, essentially it means "the subscriptions ends at midnight (00:00:00 hours) on 2018/01/01". It is written below: https://knowledgecenter.zuora.com/DC_Developers/G_SOAP_API/E1_SOAP_API_Object_Reference/Subscription > The date when the subscription term ends, where the subscription ends at midnight the day before. > For example, if the SubscriptionEndDate is 12/31/2016, the subscriptions ends at midnight (00:00:00 hours) on 12/30/2016. In such a case, it is common for my country to describe Subscription End Date 2017/12/31. Of course, essentially it means 2017/12/31 23:59:59.999.... (That is, it does not mean "the subscriptions ends at midnight (00:00:00 hours) on 2017/12/31".) I understand now. There are two ways of expressing Subscription End Date: The Subscription expires at the moment the date stated in Subscription End Date (That is, in the case of written as 2018/01/01) The Subscription expires at the moment the date ended in Subscription End Date (That is, in the case of written as 2017/12/31) Both have the same meaning. I only know about Japan. So I think that denoting Subscription End Date as "2017/12/31" may be minor and may not global standard. I want to ask everyone. How do you describe Subscription End Date in your country? * Note: I am aware of the following: The same as above applies to Subscription.TermEndDate. The same as above applies to RatePlanCharge.EffectiveEndDate

yamasaki1ma · ‎01-12-2018

I hope that will help someone: This description is correct. In order to credit back One-Time Charge, it is necessary to change the above setting to "Yes". In addition, we need to be aware of how to select the date to Remove or Cancel. We must do Remove One-Time Charge or Cancel Subscription by selecting the date on (or earlier) which One-Time Charge is enabled. If we do Remove Charge or Cancel Subscription after the date on which One-Time Charge is enabled, then One-time Charge's credit back will not occur. Specifically, The date on which One-Time Charge became enable is 2018/01/15. If we remove this Charge with 2018/01/15 (or earlier date), credit back will occur. On the other hand, if we remove this Charge with 2018/01/16 (or later date), credit back will not occur. (The same is true when we choose the date of Cancel Date of Subscription) ---- Well, I will tell you a little special case. In the case of the following scenario we need to think carefully: My customer started Subscription on 2018/01/01. A basic Charge of 1,000 yen is generated monthly (ChargeType = Recurring). I issued and posted an Invoice to the customer to charge a fee of 2018/01. Since I agreed with the customer, I issued and posted an Invoice to charge 3,000 yen as Initial Fee to 2018/01/15 (that is, ChargeType = One-Time's Charge was added to Subscripiton). However, after that, the customer offered to Cancel Subscription at the time of 2018/02/01. I will not credit back the basic monthly fee, but Initial Fee will be credit back. In this case, we can not select Cancel Date as 2018/02/01. Because Initial Fee's credit back does not occur. So, In this case, first remove Initial Fee as of 2018/01/15. After that, we do Cancel Subscription as Cancel Date to 2018/02/01.

yamasaki1ma · ‎01-08-2018

I hope that will help someone: I looked for Knowledge Center and Community. However, an example of Update RatePlanChargeTier using /v1/action/amend could not be found. I tried it and I realized it in the following way. This is the assumption: The Request: [POST] https://rest.apisandbox.zuora.com/v1/action/amend { "requests": [ { "AmendOptions": { "GenerateInvoice": true, "InvoiceProcessingOptions": { "InvoiceTargetDate": "2018-02-01" }, "ProcessPayments": false }, "Amendments": [ { "ContractEffectiveDate": "2018-02-01", "ServiceActivationDate": "2018-02-01", "CustomerAcceptanceDate": "2018-02-01", "Name": "Tier Update", "RatePlanData": { "RatePlan": { "AmendmentSubscriptionRatePlanId": "2c92c0f96078cfc60160bb32a70737e9" }, "RatePlanChargeData": [ { "RatePlanCharge": { "ProductRatePlanChargeId": "2c92c0f86078c5990160bb2c1aab2742", "Quantity": 50.0 }, "RatePlanChargeTier": [ { "Tier": 1, "Price": 500.0 }, { "Tier": 2, "Price": 400.0 }, { "Tier": 3, "Price": 250.0 } ] } ] }, "SubscriptionId": "2c92c0f96078cfc60160bb32a5cb37e2", "Type": "UpdateProduct" } ] } ] } Tips: To designate Tier, use "Tier" instead of Id. If ChargeType = Volume or Tier, specifying RatePlanCharge.Quantity is needed (even if the quantity is not changed).

yamasaki1ma · ‎12-26-2017

Thank you @Leo I confirmed your reply on ticket #138640. For Community user: My idea is right. Tenant Email setting is used only for Notification Email Template. E-mail never arrives otherwise.

yamasaki1ma · ‎12-24-2017

I did not know this field. I have been using Zuora for one year, but there are things I do not know yet! And I have doubts. Via UI, I know that there is no way to generate Invoice besides Bill Run. Meanwhile, via API, I know that there are some way to generate Invoice besides Bill Run. When using API to generate Invoice by means other than Bill Run, what value will be in this field? I tried it. Create Subscription: https://rest.apisandbox.zuora.com/v1/subscriptions Request: header: "zuora-version": "196.0" { "accountKey": "RC-00045226", "autoRenew": true, "collect": false, "contractEffectiveDate": "2018-01-01", "initialTerm": "12", "initialTermPeriodType": "Month", "invoice": true, "renewalTerm": "12", "renewalTermPeriodType": "Month", "subscribeToRatePlans": [ { "productRatePlanId": "2c92c0f95eef1984015f0415a06a785a" } ], "invoiceTargetDate": "2018-01-01", "termType": "TERMED" } Responce: { "success": true, "subscriptionId": "2c92c0fa6078c53301608710977b6958", "subscriptionNumber": "A-S00000223", "contractedMrr": 3000, "totalContractedValue": 36000, "invoiceId": "2c92c0fa6078c533016087109a706962" } I confirmed the generated Invoice from the UI. oh, I see: I don't think up the scene where this experiment is useful, but my small curiosity was satisfied.

yamasaki1ma · ‎12-17-2017

Hi all, In "Manage Tenant Profile" of administrator setting of Zuora, there is a place to set an email address. I think that filling in the email address of our customer's representative here. What kind of events will mails go to this email address? I notice that this email address will appear when setting Zuora's Notification. It appears as "Tenant Email" in the "From Email" and "Reply-to Email" choices set in Email Templates for mail sent to customers. I tried to change Email address of Tenant Profile to my email address with my Sandbox. When trying to change, the following message was displayed: > There are email templates referencing the tenant email, are you sure to change it? [ The templates will reference to new email address ] I definitely believe that the role of Tenant Email is only Notification. However, when I was asked by my customer "When is email sent to the "Email address" of Tenant Profile?", I could not answer with confidence. Is there really a role other than Notification for Tenant Email? Does anyone else know the role of Tenant Email? For example, campaign mails from Zuora will not be sent to this mail address, right? I read the "Manage Tenant Profile" page of the Knowledge Center, but I did not explain it in particular: https://knowledgecenter.zuora.com/CF_Users_and_Administrators/A_Administrator_Settings/Managing_Your_Tenant_Profile

yamasaki1ma · ‎12-16-2017

Hi All I'm writing Export ZOQL queries that I can use in several situations. However, I can not conceive of a query that works effectively under the following situation. Is this impossible with Export ZOQL (that is, I need to process exported data with Excel or program), or have another way of thinking, please lend your wisdom: The Situation: My customers have contracted Usage Charge serviece (like car sharing). Usage is imported to Zuora every time a customer uses the service. I want to identify customers who do not use the service for more than a month at the time of executing the query (I want to issue a discount to those customers). My query: select Account.Name, Account.AccountNumber, Subscription.Name, RatePlanCharge.Name, Usage.StartDateTime as LastUsedDate from Usage where (Subscription.Status = 'Active' or Subscription.Status = 'Expired') and Usage.StartDateTime < 'today - 1 month' However, with this, it is only searching Usage imported more than one month ago. The searched customer may be using the service during the past month. Is it impossible to incorporate the condition that Usage has not been imported in the past month?

yamasaki1ma · ‎12-15-2017

Hi @kopacpetr I understand that it is a fundamental problem that the size of the file you are going to download is large. If the size of the file gets smaller, your problem may be solved. > We basically load all customers , invoices etc. You write as above, but your request may be satisfied by Incremental Load. You can do Incremental Load using Zuora's AQuA Stateful Mode: https://knowledgecenter.zuora.com/DC_Developers/T_Aggregate_Query_API/BA_Stateless_and_Stateful_Modes > When you first call AQuA in stateful mode, AQuA uses the combination of partner and project as the unique identifier of a new session. The results file of the first call contains a full load of data for each of the requested queries. If you make subsequent calls with the same values of partner and project, either requesting the same queries or without any queries specified, the results file contains an incremental load of data for each query. Unfortunately, I have never used Stateful Mode. Therefore, I can not provide any further advice ...

yamasaki1ma · ‎12-15-2017

Hi @nishant I could not find the direct cause of the error in your query. By the way, this query seems to get all the fields of ProductRatePlanCharge. So I will propose. Export ZOQL can use wildcard, so how about running the following query instead of your query? SELECT *, Product.Id, ProductRatePlan.Id FROM ProductRatePlanCharge If this query satisfies your requirements, typo may be hiding in the select clause.

yamasaki1ma · ‎12-07-2017

Hi @jgallinagh I feel a sense of familiarity I also had exactly the same experience with you in my project. My solution was to run a Report that searches for any unprocessed usage after Bill Run, as you have mentioned. I share with you the functionality of Zuora I expect for "to catch it a little earlier in the process": the Notifications on Any Event feature. For details please read this post: https://community.zuora.com/t5/Subscriptions/Notification-about-new-user-account/m-p/20676 I hope that if you use this function you will be able to create a Notification triggered by "imported Usage Subscription is Expiered".

yamasaki1ma · ‎12-07-2017

Hi @appfly This "account" seems to mean Customer Account of Zuora, not banking account. Your customers each have a credit card (or debit card or Paypal or ACH ...) That is, each Account on Zuora has a different Payment Method. This error message appears when you specify a Payment Method that the Account you specified as "AccountId" does not have. In other words, the Payment Method of an Account different from the Account you specified has been entered. Your Request format will work correctly. I posted the following Request to /v1/object/payment and it processed without error: Request: { "AccountId": "2c92c0f85e1d50d8015e1ebe3e731980", "InvoiceId": "2c92c094601fa1e701602ec3ee2717b1", "amount": 1000, "AppliedInvoiceAmount": 1000, "EffectiveDate": "2017-12-07", "type": "Electronic", "PaymentMethodId": "2c92c0f95fc912e3015fdc835316789a", "gateway": "135e52f9a710b6c0014a7895947e11cd", "Status": "Processed", "Type": "Electronic" } Response: { "Success": true, "Id": "2c92c0f8601fab5701602f904d2b6110" } And I tried to set Id of another payment method that this account does not have (Before trying, I deleted the Payment object created by the above Request): I recieved the same result as the error you got. Request: { "AccountId": "2c92c0f85e1d50d8015e1ebe3e731980", "InvoiceId": "2c92c094601fa1e701602ec3ee2717b1", "amount": 1000, "AppliedInvoiceAmount": 1000, "EffectiveDate": "2017-12-07", "type": "Electronic", "PaymentMethodId": "2c92c0f95fc912e3015fdc835316789a", "gateway": "135e52f9a710b6c0014a7895947e11cd", "Status": "Processed", "Type": "Electronic" } Response: { "Errors": [ { "Code": "INVALID_VALUE", "Message": "Electronic payment and electronic method should be in the same account." } ], "Success": false } Incidentally, putting invalid values as PaymentMethodId resulted in this error. Request: { "AccountId": "2c92c0f85e1d50d8015e1ebe3e731980", "InvoiceId": "2c92c094601fa1e701602ec3ee2717b1", "amount": 1000, "AppliedInvoiceAmount": 1000, "EffectiveDate": "2017-12-07", "type": "Electronic", "PaymentMethodId": "dummy", "gateway": "135e52f9a710b6c0014a7895947e11cd", "Status": "Processed", "Type": "Electronic" } Response: { "Errors": [ { "Code": "INVALID_VALUE", "Message": "Invalid value for field PaymentMethodId: dummy" } ], "Success": false } Searching for the relationship between the Payment Method ID you received from the posted payment page and the AccountId you specified for the Request will be a clue to your problem resolution.

yamasaki1ma · ‎12-07-2017

Hi @bolaurent This discussion continues in the article you showed, and recently (July, 2017), @vu_phan indicated that this can be achieved with REST's Subscribe call https://community.zuora.com/t5/Subscriptions/REST-api-to-create-subscription-with-draft-status/td-p/12811/page/3 In fact, I confirmed that Draft's Subscription was created in this way when this was posted . (I know that Subscribe call exists from the SOAP era. What you want is just to use "Create Subscription"? If so, I can understand your thoughts very much ...!)

yamasaki1ma · ‎12-05-2017

Hi @hanah61 Rather than manipulating InvoiceItem on Nested Table, I found that there is something you want in Invoice's Merge Field: https://knowledgecenter.zuora.com/CB_Billing/IA_Invoices/Creating_a_Custom_Invoice_Template/Merge_Fields_for_Invoices#Invoice_Fields Invoice.SubTotalOneTimeChargeAmount Invoice.SubTotalRecurringChargeAmount Unfortunately, I have never used these Merge Fields myself. If you try these, please tell me the results!

yamasaki1ma · ‎11-19-2017

In Zuora, I know that the rounding method when calculating the amount can be set as follows: login name> Billing> Customize Currencies> Rounding Mode This setting affects ALL amount calculations: Charge Amount, Discount Amount and Tax Amount Please be able to separately set Rounding Mode of Charge/Discount Amount and Tax Amount respectively. ex: Rounding Mode of Charge/Discount Amount: Half Up Rounding Mode of Tax Amount: Down This example is a business practice often seen in Japan. The product and tax have different Rounding Mode. I found following Idea which is similar to this Idea. https://community.zuora.com/t5/Billing-Payment-Ideas/needs-quot-Floor-quot-style-rounding-for-tax-calculation-in/idi-p/4622 However, this Idea seems to assert "adding Floor (Down) to the Rounding Mode" (I think that it is already implemented). Rather, the essential problem is that the setting of the currency of Zuora affects all tenant's amount calculations.

yamasaki1ma · ‎11-09-2017

Hi @giosefer As far as I know, there is no API to get the list of Quote Template. On the other hand, the following Idea collects many Votes: https://community.zuora.com/t5/Admin-Settings-Ideas/Export-Import-configuration/idi-p/5922 This is Idea seeking the function to export (and import) Tenant Setting. I believe that "Tenant Setting" includes the list of Quote Template. However, despite being declared "We expect to definitely have this working in 2017", it is already November in 2017 ...

yamasaki1ma · ‎11-03-2017

Hi @leedm777 It is a simple mistake (but I also often make same type mistakes). Endpoint URL contains an error: https://rest.apisandbox.zuora.com/v1/object/subscription/{id}

yamasaki1ma · ‎11-02-2017

Hi @wojtekk In conclusion, there is no Notification triggered by creating/changing Account. But there are alternatives. I remembered reading Idea about Notification on Account (and Contact). This is: https://community.zuora.com/t5/Admin-Settings-Ideas/Create-callout-notification-for-changes-to-Contact-and-Account/idi-p/4318 The status of this Idea is already "Implemented". Sounds good. I have read through Posts of this Idea. I noticed: The implemented function is not "the Notification on Account" (this is the function you want) The implemented function is "the Notifications on Any Event feature". What is "the Notifications on Any Event feature"? I did a search in Community. I found the following articles: https://community.zuora.com/t5/Engineering-Blog/How-We-Implemented-a-Custom-Event-Framework/ba-p/19095 With this function, it seems that you can create "Notification on Account" with your hand. Zuora is planning a big update. After updating Zuora is called "Zuora Central". According to the above article, switching to Zuora Central, we are able to use "the Notifications on Any Event feature". However, In Idea mentioned above, @lukasz says that "the Notifications on Any Event feature is LA". That is, if you want to try this feature right away, you can ask Global Support to activate this feature with your tenant without waiting for Zuora Central. (I haven't activated this feature with my tenant, so I can not offer you knowledge on this feature itself, I am sorry about that)

yamasaki1ma · ‎10-31-2017

Hi @Lana It is an interesting attempt, superuser program! I will continue posting to the community so that I can be a superuser! I am pleased that the following is as perk: Private Sandbox!! My team has a Zuora Sandbox. However, because it is a team's Sandbox, it is difficult to play or experiment on my own. For example, changeing the tenant's settings, trying out the LA I care about, executing my programs affecting all records (including those created by my colleagues) ... When trying to do something like this, I need to get permission from my colleagues. I am happy that I get a Sandbox as my playground.

Happy Business Starts Here