I need to pull out a file from NetSuite then send the file to a HTTP endpoint.
The endpoint requires the payload in JSON format and the data to be in base64.
I have a step that gets the blobkey from NetSuite and a step HTTP Import (Transfer file to Application) step.
I cannot seem to get the file to transfer… below are screenshots from the HTTP Import transfer.
Can anyone provide any guidance here for me?
You're pretty close. For the "Blob key path" field, just put data.0.blobKey. Then for the value of Base64data in your request body, just put "Base64Data": "{{blob}}".
Hi Tyler,
Thanks for coming back to me… I’ve tried various variations of what you suggested…
This is where I am at the moment with it…
I still can’t seem to get the file uploaded into the endpoint application.
Any help very much welcomed.
The input data for the Import is pasted below (certain fields values are removed for sensitivity purposes)
{
"record": {
"_PARENT": {
"internalId": "",
"salesOrderNumber": "",
"customerPurchaseOrder": "",
"companyName": "",
"status": {
"exported": false,
"intStatus": "Ready"
},
"dates": {
"created": "2025-10-20",
"requestedShip": "29-Sep-2025",
"requestedDeliveryDate": "2025-09-30",
"requestedDeliveryTime": "9:00 AM"
},
"instructions": "",
"deliveryInstruction": "",
"customerType": "",
"shipVia": "5220 - 3PL - TRANSPORT",
"currency": "United Kingdom Pound",
"vatNumber": "",
"eoriNumber": "",
"orderTotalNet": "",
"orderTotalTax": "",
"orderTotalGross": "",
"contactInformation": {
"email": "",
"phone": "",
"name": "Warehouse Team",
"firstName": "Warehouse",
"lastName": "Team"
},
"deliveryAddress": {
"addressee": "C3294",
"attention": "",
"addrLine1": "",
"addrLine2": "",
"city": "",
"county": "",
"zip": "",
"country": "United Kingdom",
"countryCode": "GB"
},
"lineitems": [
{
"lineId": 1,
"sku": "",
"customerPartNumber": "54224",
"quantity": 12,
"unitPrice": ,
"totalNet": ,
"totalTax": ,
"totalAmount":
},
{
"lineId": 13,
"sku": "",
"customerPartNumber": "54226",
"quantity": 18,
"unitPrice": ,
"totalNet": ,
"totalTax": ,
"totalAmount":
},
{
"lineId": 24,
"sku": "",
"customerPartNumber": "54228",
"quantity": 12,
"unitPrice": ,
"totalNet": ,
"totalTax": ,
"totalAmount":
}
],
"response": {
"OrderId": 1107,
"Success": true,
"OrderStatus": "ONBACKORDER",
"Message": "Order Number: SO0179600 Status: ONBACKORDER"
}
},
"id": "4831488",
"recordType": "salesorder",
"Order Type": "",
"Date": "22-Sep-2025",
"Type": "Sales Order",
"Document Number": "SO0179600",
"Internal ID": "442569",
"Description": "",
"Date Created": "22-Sep-2025 12:14 PM",
"Last Modified": "22-Sep-2025 12:14 PM",
"Name": "PO A56301.xlsx",
"Size (KB)": "26",
"File Type": "Excel File",
"Owner": "",
"dataURI": "",
"filedata": [
{
"blobKey": "Replace me",
"fileMeta": {
"fileSize": 100
}
}
]
},
"connection": {
"name": "3PL - C-3PL - - Test",
"http": {
"unencrypted": {},
"encrypted": "********"
}
},
"import": {
"name": "3PL - C-3PL - - Order - Add File"
},
"job": {
"_id": "68f6715b2ae2587d7b538674",
"type": "import",
"startedAt": "2025-10-20T17:28:59.253Z",
"parentJob": {
"_id": "68f6715b2ae2587d7b538675",
"type": "flow",
"startedAt": "2025-10-20T17:28:54.253Z",
"flowExecutionGroupId": "68f6715b2ae2587d7b538676"
}
},
"testMode": true,
"settings": {
"integration": {
"ClientID": 8,
"defaultWarehouse": 6,
"Connections": [
{
"extract": "NetSuite",
"generate": ""
},
{
"extract": "MintSoft",
"generate": ""
}
],
"turnOn": 10,
"token": ""
},
"flow": {},
"flowGrouping": {
"refreshableName": [
{
"extract": "8454",
"generate": "2466"
},
{
"extract": "8455",
"generate": "2466"
},
{
"extract": "8019",
"generate": "2467"
}
]
},
"connection": {},
"iClient": {},
"import": {}
}
}
Your "Blob key path" field should just be fileData.0.blobKey. This field doesn't accept handlebar expressions and the context is already within record so you can't specify "record".
Tyler,
Ah! That now makes sense… and yes that has resolved the issue and I am now able to pass data into the HTTP endpoint correctly.
Thank you for the guidance.