I have a custom layer on the bill of lading. I need to update a custom field on the ShipHead table. I have a rest-erp call that gets the Shipment head I have a row update that updates the custom field. The part that isn’t working is the Update Call. I get no errors and here is how it is configured. I am not sure what is missing. It’s got to be something simple.
Can you confirm that your value is set correctly in the dataset by looking at the Payload of the method call?
Something like this, for example:
I can see that the dataset had the value in the console using ctrl + alt + V and the field is set. I am not sure how to check the payload.
In the Network tab, there is a list of all network calls. You’ll look for Update in that list.
I think you have to open the Network tab before you run your test for it to start listening.
So Fun note it does listen before you open it. I do see the field updated in the payload. I am only pulling the one table I want to update and only sending that one table back. I believe it should still work.
it also shows in the response if that means anything.
But it’s not showing in the database? or persisting in the CustShip?
It doesn’t get to the database.
Paste the json from the dataset.
The JSON from the Payload?
I redacted some sensitive information. The field in question is WI_ShipNum_c it’s got the info i need in it nut isn’t getting to the database.
{
"ShipHead": [
{
"Company": "WI",
"PackNum": 51091,
"ShipDate": "2024-06-25T00:00:00",
"ShipViaCode": "ODFL",
"ShipPerson": "mspotts",
"EntryPerson": "mspotts",
"ShipLog": "28254",
"LabelComment": "",
"ShipComment": "",
"Invoiced": false,
"ShipToNum": "",
"ReadyToInvoice": false,
"CustNum": 934,
"Plant": "MfgSys",
"TrackingNumber": "",
"LegalNumber": "51091",
"Voided": false,
"ExternalDeliveryNote": false,
"ExternalID": "",
"ICReceived": false,
"XRefPackNum": "",
"BTCustNum": 934,
"BTConNum": 0,
"ShipStatus": "OPEN",
"ShipGroup": "",
"PkgCode": "",
"PkgClass": "",
"Weight": 0,
"ResDelivery": false,
"SatDelivery": false,
"SatPickup": false,
"VerbalConf": false,
"Hazmat": false,
"DocOnly": false,
"RefNotes": "",
"ApplyChrg": false,
"ChrgAmount": 0,
"COD": false,
"CODFreight": false,
"CODCheck": false,
"CODAmount": 0,
"GroundType": "",
"NotifyFlag": false,
"NotifyEMail": "",
"DeclaredIns": false,
"DeclaredAmt": 0,
"MFTransNum": "",
"MFCallTag": "",
"MFPickupNum": "",
"MFDiscFreight": 0,
"MFTemplate": "",
"MFUse3B": false,
"MF3BAccount": "",
"MFDimWeight": 0,
"MFZone": "",
"MFFreightAmt": 0,
"MFOtherAmt": 0,
"MFOversized": false,
"ServSatDelivery": false,
"ServSatPickup": false,
"ServSignature": false,
"ServAlert": false,
"ServPOD": false,
"ServAOD": false,
"ServHomeDel": false,
"DeliveryType": "",
"ServDeliveryDate": null,
"ServPhone": "",
"ServInstruct": "",
"ServRelease": false,
"ServAuthNum": "",
"ServRef1": "",
"ServRef2": "",
"ServRef3": "",
"ServRef4": "",
"ServRef5": "",
"BOLNum": 28254,
"BOLLine": 1,
"CommercialInvoice": false,
"ShipExprtDeclartn": false,
"CertOfOrigin": false,
"LetterOfInstr": false,
"HazardousShipment": false,
"IntrntlShip": false,
"PayFlag": "",
"PayAccount": "",
"PayBTAddress1": "",
"PayBTAddress2": "",
"PayBTCity": "",
"PayBTState": "",
"PayBTZip": "",
"PayBTCountry": "",
"FFAddress1": "",
"FFAddress2": "",
"FFCity": "",
"FFState": "",
"FFZip": "",
"FFCountry": "",
"FFContact": "",
"FFCompName": "",
"FFPhoneNum": "",
"ChangedBy": "mspotts",
"ChangeDate": "2024-06-25T00:00:00",
"ChangeTime": 29475,
"FFID": "",
"IndividualPackIDs": false,
"FFAddress3": "",
"DeliveryConf": 1,
"AddlHdlgFlag": false,
"NonStdPkg": false,
"FFCountryNum": 0,
"PayBTAddress3": "",
"PayBTCountryNum": 0,
"PayBTPhone": "",
"WayBillNbr": "",
"FreightedShipViaCode": "",
"UPSQuantumView": false,
"UPSQVShipFromName": "",
"UPSQVMemo": "",
"PkgLength": 0,
"PkgWidth": 0,
"PkgHeight": 0,
"EDIReady": false,
"PhantomPack": false,
"ReplicatedFrom": 0,
"ReplicatedStat": "",
"PkgSizeUOM": "FT",
"WeightUOM": "LB",
"UseOTS": false,
"TranDocTypeID": "",
"DocumentPrinted": false,
"OTSOrderNum": 52369,
"TaxCalculated": false,
"TaxCalcDate": null,
"CurrencyCode": "USD",
"Rounding": 0,
"Rpt1Rounding": 0,
"Rpt2Rounding": 0,
"Rpt3Rounding": 0,
"DocRounding": 0,
"Rpt1TotalTax": 0,
"Rpt2TotalTax": 0,
"Rpt3TotalTax": 0,
"OrderAmt": 0,
"DocOrderAmt": 0,
"Rpt1OrderAmt": 0,
"Rpt2OrderAmt": 0,
"Rpt3OrderAmt": 0,
"TaxRegionCode": "",
"TotalWHTax": 0,
"DocTotalWHTax": 0,
"Rpt1TotalWHTax": 0,
"Rpt2TotalWHTax": 0,
"Rpt3TotalWHTax": 0,
"TotalSATax": 0,
"DocTotalSATax": 0,
"Rpt1TotalSATax": 0,
"Rpt2TotalSATax": 0,
"Rpt3TotalSATax": 0,
"TotalTax": 0,
"DocTotalTax": 0,
"TotalDiscount": 0,
"Rpt1TotalDiscount": 0,
"Rpt2TotalDiscount": 0,
"Rpt3TotalDiscount": 0,
"DocTotalDiscount": 0,
"ShipToCustNum": 934,
"DeviceUOM": "",
"ManifestSizeUOM": "",
"ManifestWtUOM": "",
"ManifestWeight": 0,
"ManifestLength": 0,
"ManifestWidth": 0,
"ManifestHeight": 0,
"RateGrpCode": "MAIN",
"InPrice": false,
"PBHoldNoInv": false,
"ReconcileQty": 0,
"ScheduleNumber": "Schedule Number",
"CounterASN": 0,
"OurBank": "",
"ERSOrder": false,
"AutoPrintReady": false,
"ShipOvers": false,
"WIPackSlipCreated": false,
"SysRevID": 6300079501,
"SysRowID": "854cfd9c-599a-4a99-bc7c-2248c3f19c09",
"AGAuthorizationCode": "",
"AGAuthorizationDate": null,
"AGCarrierCUIT": "",
"AGCOTMark": false,
"AGDocumentLetter": "",
"AGInvoicingPoint": "",
"AGLegalNumber": "",
"AGPrintingControlType": "",
"AGTrackLicense": "",
"DispatchReason": "",
"AGShippingWay": "",
"OurSupplierCode": "",
"ASNPrintedDate": null,
"EDIShipToNum": "",
"MXIncoterm": "",
"CreatedOn": "2024-06-25T08:07:30.273",
"DigitalSignature": "",
"SignedOn": null,
"SignedBy": "",
"FirstPrintDate": null,
"DocCopyNum": 0,
"CNDeclarationBill": "",
"CNSample": false,
"CNBonded": false,
"MXCertifiedTimestamp": null,
"MXCertificateSN": "",
"MXCertificate": "",
"MXFiscalFolio": "",
"MXSATCertificateSN": "",
"MXDigitalSeal": "",
"MXSATSeal": "",
"MXOriginalString": "",
"MXOriginalStringTFD": "",
"MXSerie": "",
"MXFolio": "",
"MXETD": null,
"MXETA": null,
"MXDistance": 0,
"MXPermitType": "",
"MXPermitNum": "",
"MXCartaPorteStatus": "0",
"VehicleLicensePlate": "",
"VehicleType": "",
"VehicleYear": 0,
"DriverID": "",
"MXCancelFiscalFolio": "",
"IncotermCode": "",
"IncotermLocation": "",
"AddrList": "",
"AllowChgAfterPrint": true,
"BillAddr": "",
"BTCustID": "",
"BTCustomerName": "",
"CartonContentValue": 0,
"CartonStageNbr": "",
"ChangeDateTime": "2024-06-25T08:11:15",
"CheckOrderMessage": "",
"CreditCardMessage": "",
"CreditHold": false,
"CtnPkgCode": "",
"DisplayInPrice": false,
"DocTaxAmt": 0,
"DocWithholdingTaxAmt": 0,
"DoPostUpdate": false,
"DspDigitalSignature": "",
"EnableAssignLegNum": false,
"EnablePackageControl": false,
"EnablePhantom": false,
"EnableShipped": true,
"EnableTax": true,
"EnableTranDocType": false,
"EnableVoidLegNum": false,
"EnableWeight": true,
"FromMasterPack": false,
"HasCartonLines": true,
"HasLegNumCnfg": false,
"LastCartonFlag": false,
"LegalNumberMessage": "",
"ManifestFlag": false,
"MasterpackPackNum": 0,
"MultipleShippers": false,
"OrderDate": "2024-06-26T12:58:46.153",
"OrderHold": false,
"OrderNum": 0,
"PCID": "",
"PhantomCasesExist": false,
"PkgHeightEnable": 0,
"PkgLenEnable": 0,
"PkgSizeUOMEnable": 0,
"PkgWidthEnable": 0,
"PostUpdMessage": "",
"QSUseBOL": false,
"QSUseCO": false,
"QSUseIntl": false,
"ReadyToInvoiceChanged": false,
"ReplicateCount": 0,
"Rpt1TaxAmt": 0,
"Rpt2TaxAmt": 0,
"Rpt3TaxAmt": 0,
"SendShipment": false,
"ShipToNumName": "",
"SlipStatus": "OPEN",
"StageShipped": false,
"StagingReq": false,
"StatusChgMessage": "",
"TaxAmt": 0,
"AutoInvoiceMessage": "",
"ShipToAddressFormatted": "",
"SoldToAddressFormatted": "",
"MXETADate": null,
"MXETATime": 0,
"MXETDDate": null,
"MXETDTime": 0,
"EnableIncotermLocation": false,
"BitFlag": 8,
"AGInvoicingPointDescription": "",
"BTCustNumInactive": false,
"CurrencyCodeCurrSymbol": "",
"CurrencyCodeCurrDesc": "USD",
"CurrencyCodeCurrencyID": "USD",
"CurrencyCodeDocumentDesc": "",
"CurrencyCodeCurrName": "USD",
"CustomerSendToFSA": false,
"CustomerInactive": false,
"CustomerBTName": "",
"CustomerCustID": "",
"CustomerName": "",
"DeliveryTypeDescription": "",
"FreightedShipViaCodeDescription": "",
"FreightedShipViaCodeWebDesc": "",
"IncotermsDescription": "",
"OurBankBankName": "",
"OurBankDescription": "",
"ShipToCustInactive": false,
"ShipToCustBTName": "",
"ShipToCustCustID": "",
"ShipToCustName": "",
"ShipToNumInactive": false,
"ShipViaCodeDescription": "",
"ShipViaCodeWebDesc": "",
"TaxRegionDescription": "",
"TranDocTypeDescription": "",
"RowMod": "",
"UD_SysRevID": "AAAAAXeDlVw=",
"WI_ShipNum_c": "C24062649082",
"WI_ShipCost_c": ""
}
],
"ShipHeadAttch": []
}
What does the other row say?
the payload and the response are blank but I am setting it. with the other field so I didn’t think to check. Why isn’t it taking the row-update. am I setting it wrong?
Relevant ?
How are you finding and selecting your row?
I am calling the get by ID and it brings back one row and I am updating that.
You still have to select that row somehow. It’s an array.
Not exactly what you need, but it illustrates using the dataview-condition widget to select rows, as well as setting up row-update.
Forgive my ignorance but I am already setting the row I want but the RowMod is not taking is so I’m not sure that I am not getting the right row. the dirty row sounds like it might be the problem but I am not sure what the solution is
