Community - About Patrick

Patrick · ‎04-12-2019

@bmesa I'll check that box every time now!

Patrick · ‎04-12-2019

@bmesa I figured it out. Liquid templating code somehow converted ">=" into ">=" and therefore it complains about "&" when I run it. In the mail editor, check the box "Disable Editor", change ">=" back to ">=", save and run and it works.

Patrick · ‎04-10-2019

After a few attempts, I'm going the support route. Thanks again!

Patrick · ‎04-09-2019

Hi @bmesa The error I got is: Liquid syntax error: Unexpected character & in "everyThird == 1 and forloop.index >= 2" I have tried: {{Data.Invoice.Balance | money: 'USD' }} it works, the output is: $16,600,000.00, I've suggested this to a customer, but he's running into issues as well, that's why I am trying to come up with an alternative. Let me try your suggestion, thank you so much!

Patrick · ‎04-09-2019

Hi all, I'm getting syntax error in Workflow for the following statement: {% if everyThird == 1 and forloop.index >= 2 %} But it runs fine here: https://jumpseller.com/support/liquid-sandbox/ In WorkFlow When I change it to: {% if everyThird == 1 and forloop.index == 2 %} It runs fine without any errors. Any ideas? Complete code: {% assign digits = Data.Invoice.AmountWithoutTax | split: '' %}{% assign pointer = digits.size | minus: 2 %}{% assign remainderP = digits.size | minus: 1 %}{% assign decPoint = digits[pointer] %}{% assign remainder = digits[remainderP] %}{% capture new_var %}{{ decPoint }}{{ remainder }}{% endcapture %}{{ "$" }}{% for digit in digits %}{% assign everyThird = digits.size | minus: forloop.index | modulo: 3 %}{% if everyThird == 1 and forloop.index >= 2 %}{% if forloop.index >= pointer %}{{ new_var }}{% break %}{% endif %}{{ digit | prepend: ',' }}{% else %}{{ digit }}{% endif %}{% endfor %} Thanks in advance!

Patrick · ‎10-02-2018

Hi @combsCombs, You can find this information in "Payment Transaction Log", it can be access via REST or UI. We also provide "Payment Method Transaction Log" via REST and UI as well to capture data sent/receive during payment method authorization. Hope this helps! Thank you @combsCombs!

Patrick · ‎08-16-2018

Hi @rajpc, AQuA is gear towards more of a data replication type of use cases. For example, pulling data once a week or once a month into a data warehouse for other reporting purposes. So if you'ure after more of a 'real-time' type of calls, I would recommend our REST API offerings (here). Thanks!

Patrick · ‎06-26-2018

Hi @ayonge, you're correct that Zuora cannot push the data to localhost URL for callbacks, glad to hear it works in public URL. Thanks!!

Patrick · ‎06-20-2018

My pleasure!

Patrick · ‎06-20-2018

Hi @ayonge! Given that HPM created ACH payment method successfully, it will return a payment method ID. The next step would be updating an account's default payment method with this newly created ID. Note that the default payment method is associated with Account object. Below is the details of my test. PUT call to endpoint below, note that this is for sandbox and account ID at the end of endpoint: https://rest.apisandbox.zuora.com/v1/object/account/2c92c0f950e512ab0150f2459b340223 Request: { "DefaultPaymentMethodId": "2c92c0f863f7f04001641f0d43367aa6" } Response: { "Success": true, "Id": "2c92c0f950e512ab0150f2459b340223" } Give this a try and let us know how this goes? Thank you! Refrence: https://www.zuora.com/developer/api-reference/#operation/Object_PUTAccount

Patrick · ‎06-07-2018

Hi @lisaluque, At the moment, I'm not aware if we have any limits in terms of how many payment methods can be added. Do you have any particular number in mind? Thank you!

Patrick · ‎06-07-2018

Hi @ayonge, POST call per requested, you can provide the child tenant's ID in the query, and you will receive the ultimate parent ID. docs: https://www.zuora.com/developer/api-reference/#operation/Action_POSTquery endpoint: https://rest.apisandbox.zuora.com/v1/action/query Request Body: { "queryString": "select ParentId from Account where Id = '2c92c0f963da67f80163dc5b16d631e3'" } Response: { "records": [ { "ParentId": "2c92c0f963da67f70163dc5a61972eb8", "Id": "2c92c0f963da67f80163dc5b16d631e3" } ], "size": 1, "done": true } Or, you can use GET call as well, you will see "parentId" under "basicinfo" in the JSON returned. GET call with endpoint: https://rest.apisandbox.zuora.com/v1/accounts/2c92c0f963da67f80163dc5b16d631e3 docs: https://www.zuora.com/developer/api-reference/#operation/GET_Account Hope this helps, thank you!

Patrick · ‎06-07-2018

Hi @gbarak! As you probably figured out, there isn't a direct way to retrieve this this information. I have tested this out and maybe you can give it a try and see whether it suits your needs. It is a little bit clunky, requiring total of 3 API calls. Basically, query a joint object of "Subscription", "InvoiceItem" and "Account", the end result is a list of subcription IDs if these subscriptions have invoiceItem IDs associated with them, meaning invoice had been generated. You can reference the joint object "InvoiceItem" if you're interested querying other fields of the joint objects. Call #1 Create an "Export" object via "Export ZOQL", you can see in the query, we start by querying a particular account, the object we're interested in would be "Invoice Item". Documentation to the endpoint below is here. POST endpoint: https://rest.apisandbox.zuora.com/v1/action/create Request body: { "objects": [ { "Format": "csv", "Query": "select Subscription.Id from InvoiceItem where Account.Id = '8f4552ccc597e11cec53f19b085b849b'" } ], "type": "Export" } Response: [ { "Success": true, "Id": "2c92c0f963da67f80163db4e7fa2553d" } ] Call #2 Query for the "FileId" from Call #1 above, documentation to this endpoint is here. POST endpoint: https://rest.apisandbox.zuora.com/v1/action/query Request body: { "queryString": "select FileId from Export where Id = '2c92c0f963da67f80163db4e7fa2553d'" } Response: { "records": [ { "FileId": "2c92c08663da68b40163db4e80980d17", "Id": "2c92c0f963da67f80163db4e7fa2553d" } ], "size": 1, "done": true } Call #3 Retrieve results by providing "FileId" from Call #2, documentation to endpoint is here. If there are no IDs in the response, that means no invoice been generated. You can further query the subscripitions in the account to find out exactly which subscriptions do not have invoice generated. GET endpoint: https://rest.apisandbox.zuora.com/v1/files/2c92c08663da68b40163db4e80980d17 Response: Subscription.Id 8f4552cca6fc880d090ef2f202bd2f38 8f4552cca6fc880d090ef2f202bd2f38 8f4552cca6fc880d090ef2f202bd2f38 8f4552cca6fc880d090ef2f202bd2f38 8f4552cce0408f934c5f21724d7cdff6 8f4552cce0408f934c5f21724d7cdff6 8f4552cce0408f934c5f21724d7cdff6 8f4552cce0408f934c5f21724d7cdff6 8f4552cce0408f934c5f21724d7cdff6 8f4552cce0408f934c5f21724d7cdff6 8f4552cce0408f934c5f21724d7cdff6 8f4552cce0408f934c5f21724d7cdff6 8f4552cce0408f934c5f21724d7cdff6 8f4552cce0408f934c5f21724d7cdff6 8f4552cce0408f934c5f21724d7cdff6 8f4552cc03fe909ac7099986688108bd 8f4552cc03fe909ac7099986688108bd 8f4552cc03fe909ac7099986688108bd 8f4552cc03fe909ac7099986688108bd 8f4552cc03fe909ac7099986688108bd 8f4552cc03fe909ac7099986688108bd Hope this helps, thank you!

Patrick · ‎03-29-2018

Hi @David_C, Got the information from our Payment Product Manager that we will upgrade to REST at some point later this year. As soon as we have more concrete plans we will let our customers know via Community. Thank you so very much for your patience!

Patrick · ‎02-16-2018

Hi David, I'm still investigating interally with our team, I'll report back as soon as possible, thank you very much for your patience!

Patrick · ‎02-07-2018

Here's a screenshot from Viktor's suggestion for better clarity. "Gateway Type" values mentioned, these are the payment gateways configured in your tenant, choose the gateway used to process this payment initially: You can view the list by going to: https://www.zuora.com/apps/PaymentLog.do?method=addTransactionLog&paymentID=[PAYMENT_ID]

Patrick · ‎02-02-2018

Hi David, Let me follow up with our team and get back to you. Thank you!

Patrick · ‎12-08-2017

Patrick · ‎10-02-2017

If you have issues loading the CAPTCHA screen, please check and make sure you're using TLS1.1+ as TLS1.0 is not supported. Thank you!

Patrick · ‎07-25-2017

Hi pfranzoni, I did a quick test with Postman and the call was successful. Below is my test info: Endpoint: https://rest.apisandbox.zuora.com/v1/object/export Request: { "Format": "csv", "Name": "test_Export_1476935164445", "Query": "select * from account", "Status": "Processing", "Zip": true } Response: { "Success": true, "Id": "2c92c0f85d5964dc015d7bf3973257e3" } May I ask if you can try Curl and see whether the call is successful? Below sample is from our documentation here. curl -X POST -H \"apiAccessKeyId: dummyUser\" -H \"apiSecretAccessKey: dummyPassword\" -H \"Content-Type: application/json\" -d '{\n \"Format\": \"csv\", \n \"Name\": \"test_Export_1476935164445\", \n \"Query\": \"select * from account\", \n \"Status\": \"Processing\", \n \"Zip\": true\n}' \"https://rest.zuora.com/v1/object/export\"

Patrick · ‎07-06-2017

Hi hachemabidi, It is by design. Reason being is that the purpose of discount charge is to lower the amount, with discount on a negative charge, the result would be increasing the amount instead. Therefore, regardless whether it is usage or not, this is not supported. Hope this helps. Thank you!

Patrick · ‎05-18-2017

Solution: This can be done by simply do a post request with the field in the body: { "Example": "value"}

Patrick · ‎05-18-2017

Problem Statement: When I create a required input parameter, how do I specify it in a POST request? Example: I made Account Number a required parameter: The standard request URL to kick off the workflow is: https://workflow.apps.zuora.com/api/v1/workflows/10/run

Patrick · ‎05-16-2017

Solution: Potentially it might have to do with caching issues. There are 2 things you can try to get around this to confirm: 1, Use CURL command or Postman (another Chrome Extension) to bypass ARC to isolate whether the issue is on Zuora side or the tool side. 2, Clear your browswer cache and try again Supporting Documentation: https://www.lifewire.com/how-to-fix-a-400-bad-request-error-2617988 https://www.zuora.com/developer/api-reference/

Patrick · ‎05-16-2017

Problem: I have been using the same REST API call via Advanced REST Client, a Google Chrome Extension. It's been working fine, now I keep getting error 400 Bad Request, why are my calls failing?

Patrick · ‎05-11-2017

Solution: 1, First, please check with Zuora Support to see whether tenant level permission of Custom Foreign Currency is enabled. 2, If enabled, please check csv format against attachment "TEST.csv". Note that the date format must be "YYYY-MM-DD" 3, REST call via CURL to upload the csv file: curl -H "apiAccessKeyId:USERNAME" -H "apiSecretAccessKey:PASSWORD" -H "Accept:application/json" --form "file=@TEST.csv" --form "params={actionType:ImportFXRate}" -X POST https://apisandbox-api.zuora.com/rest/v1/bulk 4, Upload should be successful. If not, in the UI, please go to "Finance" > "Mass Updater", there in the dropdown box "Mass Action to Perform", select "Import Foreign Exchange Rates". Then under the column "Response File", you will be able to download the result file with better error messages for troubleshooting. Reference: https://knowledgecenter.zuora.com/DC_Developers/C_REST_API/B_REST_API_reference/Mass_Updater/A_Perform_Mass_Action https://knowledgecenter.zuora.com/CC_Finance/Mass_Updater/Import_Foreign_Exchange_Rates

Patrick · ‎05-11-2017

Problem: I've been getting the error when uploading via endpoint: https://apisandbox-api.zuora.com/rest/v1/bulk?actionType=ImportFXRate Error: { "success" : false, "processId" : "B30180B83EC12345", "reasons" : [ { "code" : 57040000, "message" : "org.apache.catalina.connector.RequestFacade cannot be cast to org.springframework.web.multipart.MultipartHttpServletRequest" } ] }

Patrick · ‎04-25-2017

Known Error: When upload usage file via API, intermittent failures with the error message: "Import Status: Failed Status Description: The usage file must be in valid CSV format." If retry the upload, the can be processed successfully. Status: Our Engineering team has identified the issue. The fix will be deployed in release R-221, tentatively 5/10/2017 to sandbox and 5/17/2017 to production. Reference Number: BIL-21231

Patrick · ‎04-09-2017

Solution: To update multiple Rate Plan Charges in a single amendment call, there are 2 ways since the Rate Plan Charges could be from different Rate Plans. For Rate Plan Charges that are from the same Rate Plan the format of the XML tags are: - amend() - Amendment - Rate Plan - Rate Plan Charge - Rate Plan Charge For Rate Plan Charges that are from different Rate Plan, the format is: - amend() - Amendment - Rate Plan A - Rate Plan Charge - Amendment - Rate Plan B - Rate Plan Charge

Patrick · ‎04-09-2017

Question: In this Knowledge Center article, it only shows changing a single RatePlan Charge in an amendment. How do I update multiple Rate Plan charges in a single amendment call? What is the XML format?

Happy Business Starts Here