Community - About gbordawekar

gbordawekar · ‎11-19-2018

Seems like the new REST API still not available on the Production Copy (ServicesX) Environment. I am getting a 500 Internal server error on HTTP POST with the querystring posted to https://servicesX.zuora.com/apps/v1/action/query.

gbordawekar · ‎07-12-2018

Hi Looking for a solution - to validate the payment fields for the correct format (specifically phone field, if email format fails then it's returned as a BusinessValidationError in the errorMessageCallback function) enable the submit button (embedded in the iFrame) from the callback function and allowing the user to re-submit.

gbordawekar · ‎07-12-2018

@rjohnson Thanks for addressing my query. We already have implemented these changes (Enable client-side validation is ON with custom error message). In our MVC .net app I have implemented the custom error message handling using errorMessageCallback function as defined in https://knowledgecenter.zuora.com/CB_Billing/LA_Hosted_Payment_Pages/B_Payment_Pages_2.0/N_Error_Handling_for_Payment_Pages_2.0/Customize_Error_Messages_for_Payment_Pages_2.0 However Zuora's client side validation returns error messages only when the required fields are not completed or if the CC number fails the checksum ("HostedPageFieldValidationError" errors). I am looking for assistance in validating the payment form fields on the client side for the correct format.. e.g. phone number format. currently if the phone field is filled in then the Callback function gets called and then I have to validate the phone format by checking the response.phone. but now once the callback function is called, the (inside) zuora diables the Submit button on the the HPP and I don't have a way to re-enable it to allow the user to enter the phone in the correct format and re-submit the Payment. Looking for a solution - to validate the payment fields for the correct format (specifically phone field, if email format fails then it's returned as a BusinessValidationError in the errorMessageCallback function) enable the submit button (embedded in the iFrame) from the callback function and allowing the user to re-submit.

gbordawekar · ‎05-11-2018

I am looking for client side validation on all the text input fields on the payment form. Does the zuora client library have any in-built validation to allow / set validation rules on the text input fields such as the phone field ? if the email field is not in the correct format then the Payament Page 2.0 validates and returns and invalid email in the client side error message (provided the email field was marked as Required). However it doesn't validate the rest of the text input fields - for instance the phone field can take in invalid phone number or all text and no error returned in the callback.

gbordawekar · ‎02-04-2018

It should be " https://rest.sandbox.eu.zuora.com/ v1/object/bill-run "

gbordawekar · ‎01-16-2018

Is it possible to access the email templates via REST api? I have a need to send email notifications using the existing template on our tenant.

gbordawekar · ‎01-16-2018

Is it possible to access the email templates via REST api? I have a need to send email notification using the exsiting template on our tenant.

gbordawekar · ‎01-04-2018

Given a specific account id, payment id; I would like to report the event details on the Payment Processed callout. I am interested in pulling the attempt number and the response code that Zuora received in particular. GET https://apisandbox-api.zuora.com/rest/v1/notification-history/callout - This REST endpoint accepts an ObjectId and start/ end datetimestamps but it seemed to be ignoring the request parametres and returning too many records . Is it possble to narrow the data it returns in the JSON to a specific callout instance ?

gbordawekar · ‎01-31-2017

Given a Payment ID, how do I retrieve the ID/ type/ Description on all the Amendments associated on the Payment transaction? Is there a REST api call to do it ? or do I need to do a data export using the subscription on the Payment?

gbordawekar · ‎01-18-2017

I updated the "content-type" to "application/json". and here 's the updated PostMan request header and the response. var settings = { "async": true, "crossDomain": true, "url": "https://apisandbox.zuora.com/apps/api/batch-query/", "method": "POST", "headers": { "authorization": "###", "content-type": "application/json", "cache-control": "no-cache", "postman-token": "4ff4115f-a1ac-2e22-b588-4b3ce852aeab" }, "data": { "format": "csv", "version": "1.1", "name": "Example", "encrypted": "none", "useQueryLabels": "true", "dateTimeUtc": "true", "queries": "[ { \"name\" : \"AccountingPeriod\", \"query\" : \"select Id,StartDate,EndDate,FiscalYear,Name,Status from AccountingPeriod\", \"type\" : \"zoqlexport\" }]" } } $.ajax(settings).done(function (response) { console.log(response); }); Response from Zuora - {"Error":"Could not read JSON: Unrecognized token 'fomtcvvrin11nm': was expecting 'null', 'true', 'false' or NaN\n at [Source: org.apache.catalina.connector.CoyoteInputStream@646cdfdc; line: 1, column: 29]; nested exception is org.codehaus.jackson.JsonParseException: Unrecognized token 'fomtcvvrin11nm': was expecting 'null', 'true', 'false' or NaN\n at [Source: org.apache.catalina.connector.CoyoteInputStream@646cdfdc; line: 1, column: 29]"}

gbordawekar · ‎01-18-2017

This is all I could capture - POST https://apisandbox.zuora.com/apps/api/batch-query/ HTTP/1.1 Accept: application/json Authorization: #### User-Agent: RestSharp/105.2.3.0 Content-Type: application/x-www-form-urlencoded Host: apisandbox.zuora.com Content-Length: 329 Accept-Encoding: gzip, deflate Connection: Keep-Alive format=csv&version=1.1&name=Example&encrypted=none&useQueryLabels=true&dateTimeUtc=true&queries=%5B%7B%22name%22%3A%22AccountingPeriod%22%2C%22query%22%3A%22select%20Id%2CStartDate%2CEndDate%2CFiscalYear%2CName%2CStatus%20from%20AccountingPeriod%22%2C%22type%22%3A%22zoql%22%2C%22apiversion%22%3Anull%2C%22deleted%22%3Anull%7D%5D ========= PostMan also receives the 500 error and had the following in the request - var settings = { "async": true, "crossDomain": true, "url": "https://apisandbox.zuora.com/apps/api/batch-query/", "method": "POST", "headers": { "authorization": "####", "content-type": "application/x-www-form-urlencoded", "cache-control": "no-cache", "postman-token": "1253560a-0b9a-73b1-b0ab-1a2668a3fe07" }, "data": { "format": "csv", "version": "1.1", "name": "Example", "encrypted": "none", "useQueryLabels": "true", "dateTimeUtc": "true", "queries": "[ { \"name\" : \"AccountingPeriod\", \"query\" : \"select Id,StartDate,EndDate,FiscalYear,Name,Status from AccountingPeriod\", \"type\" : \"zoqlexport\" }]" } } $.ajax(settings).done(function (response) { console.log(response); });

gbordawekar · ‎01-17-2017

The code (C#) - string sBaseURL; string sUsername = ""; string sPassword = ""; //Sandbox sBaseURL = "https://apisandbox.zuora.com/apps/api/batch-query/"; sUsername = "gbordawekar@ZuoraFullsand.com"; sPassword = "<enter your password>"; var client = new RestClient(sBaseURL); client.Authenticator = new HttpBasicAuthenticator(sUsername, sPassword); //JSON array object to hold the Queries data QueryHolder[] queriesArr = new QueryHolder[] { new QueryHolder() { name = "AccountingPeriod", query = "select Id,StartDate,EndDate,FiscalYear,Name,Status from AccountingPeriod", type = "zoqlexport" }, }; JavaScriptSerializer js = new JavaScriptSerializer(); string queriesJson = JsonConvert.SerializeObject(queriesArr); var request = new RestRequest(Method.POST); request.AddParameter("format", "csv"); request.AddParameter("version", "1.1"); request.AddParameter("name", "Example"); request.AddParameter("encrypted", "none"); request.AddParameter("useQueryLabels", "true"); request.AddParameter("project", System.DBNull.Value); request.AddParameter("partner", System.DBNull.Value); //request.AddParameter("notifyurl", " "); // TBD request.AddParameter("dateTimeUtc", "true"); request.AddParameter("queries", queriesJson); // execute the request IRestResponse response = client.Execute(request); => Returns the "Internal Server Error" var content = response.Content; // raw content as string //JavaScriptSerializer js = new JavaScriptSerializer(); var dict = js.Deserialize<Dictionary<string, dynamic>>(response.Content);

gbordawekar · ‎01-17-2017

I am running into an "Internal server Error" on making the AQuA API POST Request with a ZOQL through a custom C# code. I am using RestClient. The POST request is made to https://apisandbox.zuora.com/apps/api/batch-query/ . The Response doesn't give any more details. what could be the cause? Is there a C# sample available ? https://knowledgecenter.zuora.com/DC_Developers/Aggregate_Query_API/B_Submit_Query

gbordawekar · ‎09-01-2016

Request URL: https://api.zuora.com/rest/v1/notification-history/email I have set the "FailedOnly" setting to false but the call is not returning any records. Here is my request header for the email notification REST call - GET /rest/v1/notification-history/email HTTP/1.1 Host: api.zuora.com startTime: 2016-08-31T00:00:00 endTime: 2016-09-01T00:00:00 failedOnly: false eventCategory: 2120 pageSize: 1 Authorization: Basic ######## Cache-Control: no-cache Postman-Token: 009f41dc-786d-20e1-aeaf-7c3f36857669 Postman returns the response as { "emailHistories" : [ ], "success" : true } Ideally the eventCategory is different than the one I have used above but for testing purposes I am using 2120 ( Payment Processed). Any idea why the call is not returning all records for the given date range/ category?

gbordawekar · ‎08-19-2016

Hi @OmarArroum I used your URL and it worked for me through Postman. Then I compared all the 3 URLs (KB, mine with error, yours) and noticed that the URL is case senstitive. KB mentions the sandbox URL with "V1" which results in error. It needs to be "v1" for a success response. I was able to switch the URLs and can replicate the error in Postman. suggest to fix the typo in the KB 🙂 Thanks for your help. Gauri

gbordawekar · ‎08-19-2016

What is the correct base URL for the REST API call in sandbox? Followed the details in the kowledge base but get a Page Not fund error for sandbox. The production REST api call works. Here's my test - https://apisandbox-api.zuora.com/rest/V1/notification-history/email?startTime=2015-01-12T00:00:00&endTime=2015-01-15T00:00:00&failedOnly=false&eventCategory=1000&pageSize=1 Gauri

gbordawekar · ‎07-14-2016

The custom field is available to send to the callout in the "Delivery Options" but its not available under the "Event Parameters" dropdown list.

gbordawekar · ‎07-13-2016

We have a similar requirement. It will be helpful to be able to use a custom field as a parameter in a callout notification; such as using a Custom Date field in the Key Date(s) | Subscription Start Date callout. Is this feature in the works?

gbordawekar · ‎07-08-2016

Currently we have set the Hosted Payment Page 1.0 with our default gateway setting and we use direct post submission and not iFrame. In the coming months, we would be adding more instances of gateways for each division of our organization. Should we create a different HPP per each gateway and then load based upon the source entity? Or is there any way to point the HPP page to a different gateway at run time? What is the recommendation if we need to load a Hosted Payment Page with a different gateway instance?

gbordawekar · ‎06-14-2016

Is the custom field "Internal Notes" available through SOAP API? or would it rather make sense that we create a similar custom field on the Payment object to manage the customized notes for our billing purposes?

gbordawekar · ‎06-14-2016

Ability to update the data on the Payment object after its created. Currently once the payment object is created, the Comment field was not updatable and SOAP API update call on the payment object returns a errorr "Field Not Updatable".

Happy Business Starts Here

Vision

Products

Zuora Central Platform

Products

Zuora Marketplace

Solutions

By Industry

By Role

Customers

Resources

Resources

Subscribed

Support

Company

Re: What are the Correct REST endpoints for Production Copy (ServicesX) Environment?

hosted payment page 2.0 with inside submit

Re: Payment Page 2.0 form fields validation

Payment Page 2.0 form fields validation

Re: Zuora rest api /v1/object/bil-run json format of the request

How to query email template using REST api

Access email template via REST api

Notification History GET call returning too many records

Query Amendments on a Payment

Re: AQuA API - Internal Server Error

Re: AQuA API - Internal Server Error

Re: AQuA API - Internal Server Error

AQuA API - Internal Server Error

Email notification REST API returns no data when ""FailedOnly"is set to false

Re: Not found error in sandbox for Email notification REST API

Not found error in sandbox for Email notification REST API

Re: Enable use of custom fields as callout parameters

Re: Enable use of custom fields as callout parameters

Configuring Hosted Payment Page with different gateways

Re: Ability to update the data on the Payment object after its created.

Ability to update the data on the Payment object after its created.