-
Trustpilot AFS json on email templates
Hello everyone, I am trying to integrate the TrustPilot's AFS onto our email templates. The article here, I can copy the code onto the <body> tag of the templte. <script type="application/json+trustpilot"> { "recipientName": "<NLCUSTOMERNAME>", "recipientEmail": "<NLEMAIL> ", "referenceId": "<NLORDERCONFIRMATIONNUMBER>",…
-
REGEXP_SUBSTR - JSON DECODE
Hi, I'm trying to decode a JSON to get a field for a saved search, but i would like to go through the structure of the JSON this is my JSON "committente": { "cf": "00180940041", "denominazione": "S.A.I.S.E.F. SPA", "piva": "IT00180940041", "indirizzo": "VIA VITTORIO VENETO N. 4", "cap": "12084", "comune": "MONDOVI'",…
-
purchase event on confirmation page
Hello Everyone, I am looking to integrate the following script from google onto our order confirmation theme file. gtag("event", "purchase", { transaction_id: "T_12345_1", value: 25.42, tax: 4.90, shipping: 5.99, currency: "USD", coupon: "SUMMER_SALE", items: [ // If someone purchases more than one item, // you can add…
-
How can I insert a Netsuite inventory adjustment with lot numbered items with suitetalk?
I don't know how to configure the inventory detail in the JSON I'm trying to POST at https://<<myacc>>.suitetalk.api.netsuite.com/services/rest/record/v1/inventoryAdjustment this JSON { "account": 4738, "trandate":"2022-11-14", "subsidiary":3, "inventory": { "items": [ { "item": 9908, "location":25, "adjustQtyBy": 100,…
-
Help needed differentiating similar named fields in jSON results with REST API
Hi, When I do a non basic REST API query like : SELECT * FROM transactionline tl, transaction t, customer c WHERE transaction > 123 and tl.transaction = t.id and t.entity = c.id" The result comes back with similar named fields like: "currency" : "xxx", "currency_0" : "xxx", "entity" : "xxx", "entity_0" : "xxx", "id" :…
-
Item object from REST OData API - where is "Units Type" field?
When I look at an Item in NetSuite, I can seethe Units Type field, which defines which Units apply to this Item: That defines that for example, by default this item will come up as "Each" on a Sales Order, but I could also sell it by Case. But when I fetch this object from the OData API, I see the Primary Stock Unit,…