It allows you:
to get the Asset list
Columns that can be used as filters:
Organization_ID
Organization
Asset_ID
Value
Active
SerNo
AssetServiceDate
GuaranteeDate
AssetGroup_ID
AssetGroup
Owned
InPosession
BPartnerSR_ID
BPartnerSR
BPartner_ID
BPartnerValue
UserEmail
Project_ID
ProjectValue
PrjCounty
PrjRegion
NextMaintenanceDate
CurrentBPartner_ID
CurrentBPartnerValue
CurrentBPartnerName
CurrentUserEmail
LastModified
BPartnerValue_List (JSON Array format ex: ['ABC','C1'])
Asset_ID_List (JSON Array format ex: [1000001,1000002])
Actions can be done:
list
create
update
URL: https://api.socratecloud.com/webapi/rest/asset/list/{version}?startRow={0}&endRow={100}&accessToken={access_token}
Method: GET
Return: JSON object with next format:
{
"data": [
{
"Organization_ID": 1000052,
"Organization": "Test A SRL",
"Asset_ID": 1001773,
"Value": "MAROMA_MFL-L003_504327_1",
"Name": "MAROMA ADVERTISING SRL - L003 - marfa-fifo-lot",
"Description": null,
"Help": null,
"Active": true,
"Product_ID": 1000384,
"ProductName": "L003 - marfa-fifo-lot",
"ProductValue": "MFL-L003",
"ProductFamily_ID": 1000003,
"ProductFamily": "Fam.2a",
"attributes": {
"AttributeSet_ID": 1000053,
"AttributeSet": "LOT+DATA GARANTIE",
"BatchLot": "PECO-PRD-2015",
"GuaranteeDate": "2016-04-01 00:00:00+0300",
"SerNo": null,
"Lot_ID": null,
"Lot": null,
"Description": "«PECO-PRD-2015»_04/01/2016"
},
"VersionNo": null,
"Lot": "PECO-PRD-2015",
"SerNo": null,
"AssetServiceDate": "2018-01-29 00:00:00+0200",
"GuaranteeDate": "2018-04-29 00:00:00+0300",
"AssetGroup_ID": 1000417,
"AssetGroup": "9999 LIVRABILE",
"Qty": 1,
"Owned": false,
"InPosession": false,
"BPartnerSR_ID": null,
"BPartnerSR": null,
"BPartner_ID": 1007970,
"BPartnerValue": "MAROMA",
"BPartnerName": "MAROMA ADVERTISING SRL",
"User_ID": 1008748,
"UserName": "Max",
"UserEmail": null,
"UserPhone": null,
"BPartnerLocation_ID": 1007673,
"BPartnerLocation": "HARMAN",
"BPAddress": "STR. EREMIA GRIGORESCU, , , ",
"BPCounty": "HARMAN",
"BPRegion": "Brasov",
"Project_ID": null,
"ProjectValue": null,
"ProjectName": null,
"PrjBPLocation_ID": null,
"PrjBPLocation": null,
"PrjAddress": ", , , ",
"PrjCounty": null,
"PrjRegion": null,
"LastMaintenanceUnit": null,
"LastMaintenanceDate": null,
"LastMaintenanceNote": null,
"NextMaintenenceUnit": null,
"NextMaintenenceDate": null,
"CurrentBPartner_ID": 1007970,
"CurrentBPartnerValue": "MAROMA",
"CurrentBPartnerName": "MAROMA ADVERTISING SRL",
"CurrentBPartnerLocation_ID": 1007673,
"CurrentBPartnerLocation": "HARMAN",
"CurrentBPAddress": "STR. EREMIA GRIGORESCU, , , ",
"CurrentBPCounty": "HARMAN",
"CurrentBPRegion": "Brasov",
"CurrentUser_ID": 1008748,
"CurrentUser": "Max",
"CurrentUserEmail": null,
"CurrentUserPhone": null,
"ExtendedGuarantee": null,
"PostGuarantee": false,
"Lead_ID": 1000037,
"SystemStatus": "Production"
}
],
"totalRows": 1
}
URL: https://api.socratecloud.com/webapi/rest/asset/create/{version}?accessToken={access_token}
Method: POST
Return: asset value for success or error message (start with "ERROR: ")
Data format:
{
"Organization_ID": 1000052,
"Organization": "Test A SRL",
"Value": "MAROMA_MFL-L003_504327_1",
"Name": "MAROMA ADVERTISING SRL - L003 - marfa-fifo-lot",
"Description": null,
"Help": null,
"Active": true,
"Product_ID": 1000384,
"ProductName": "L003 - marfa-fifo-lot",
"ProductValue": "MFL-L003",
"ProductFamily_ID": 1000003,
"ProductFamily": "Fam.2a",
"VersionNo": null,
"Lot": "PECO-PRD-2015",
"SerNo": null,
"AssetServiceDate": "2018-01-29 00:00:00+0200",
"GuaranteeDate": "2018-04-29 00:00:00+0300",
"AssetGroup_ID": 1000417,
"AssetGroup": "9999 LIVRABILE",
"Qty": 1,
"Owned": false,
"InPosession": false,
"BPartnerSR_ID": null,
"BPartnerSR": null,
"BPartner_ID": 1007970,
"BPartnerValue": "MAROMA",
"BPartnerName": "MAROMA ADVERTISING SRL",
"User_ID": 1008748,
"UserName": "Max",
"UserEmail": null,
"UserPhone": null,
"BPartnerLocation_ID": 1007673,
"BPartnerLocation": "HARMAN",
"BPAddress": "STR. EREMIA GRIGORESCU, , , ",
"BPCounty": "HARMAN",
"BPRegion": "Brasov",
"Project_ID": null,
"ProjectValue": null,
"ProjectName": null,
"PrjBPLocation_ID": null,
"PrjBPLocation": null,
"PrjAddress": ", , , ",
"PrjCounty": null,
"PrjRegion": null,
"LastMaintenanceUnit": null,
"LastMaintenanceDate": null,
"LastMaintenanceNote": null,
"NextMaintenenceUnit": null,
"NextMaintenenceDate": null,
"CurrentBPartner_ID": 1007970,
"CurrentBPartnerValue": "MAROMA",
"CurrentBPartnerName": "MAROMA ADVERTISING SRL",
"CurrentBPartnerLocation_ID": 1007673,
"CurrentBPartnerLocation": "HARMAN",
"CurrentBPAddress": "STR. EREMIA GRIGORESCU, , , ",
"CurrentBPCounty": "HARMAN",
"CurrentBPRegion": "Brasov",
"CurrentUser_ID": 1008748,
"CurrentUser": "Max",
"CurrentUserEmail": null,
"CurrentUserPhone": null,
"ExtendedGuarantee": null,
"PostGuarantee": false,
"Lead_ID": 1000037,
"SystemStatus": "Production"
}
URL: https://api.socratecloud.com/webapi/rest/asset/update/{version}?accessToken={access_token}&Value={asset_value}&Asset_ID={asset_id}
Method: POST
Return: asset value for success or error message (start with "ERROR: ")
Data format:
{
"Organization_ID": 1000052,
"Organization": "Test A SRL",
"Asset_ID": 1001773,
"Value": "MAROMA_MFL-L003_504327_1",
"Name": "MAROMA ADVERTISING SRL - L003 - marfa-fifo-lot",
"Description": null,
"Help": null,
"Active": true,
"Product_ID": 1000384,
"ProductName": "L003 - marfa-fifo-lot",
"ProductValue": "MFL-L003",
"ProductFamily_ID": 1000003,
"ProductFamily": "Fam.2a",
"VersionNo": null,
"Lot": "PECO-PRD-2015",
"SerNo": null,
"AssetServiceDate": "2018-01-29 00:00:00+0200",
"GuaranteeDate": "2018-04-29 00:00:00+0300",
"AssetGroup_ID": 1000417,
"AssetGroup": "9999 LIVRABILE",
"Qty": 1,
"Owned": false,
"InPosession": false,
"BPartnerSR_ID": null,
"BPartnerSR": null,
"BPartner_ID": 1007970,
"BPartnerValue": "MAROMA",
"BPartnerName": "MAROMA ADVERTISING SRL",
"User_ID": 1008748,
"UserName": "Max",
"UserEmail": null,
"UserPhone": null,
"BPartnerLocation_ID": 1007673,
"BPartnerLocation": "HARMAN",
"BPAddress": "STR. EREMIA GRIGORESCU, , , ",
"BPCounty": "HARMAN",
"BPRegion": "Brasov",
"Project_ID": null,
"ProjectValue": null,
"ProjectName": null,
"PrjBPLocation_ID": null,
"PrjBPLocation": null,
"PrjAddress": ", , , ",
"PrjCounty": null,
"PrjRegion": null,
"LastMaintenanceUnit": null,
"LastMaintenanceDate": null,
"LastMaintenanceNote": null,
"NextMaintenenceUnit": null,
"NextMaintenenceDate": null,
"CurrentBPartner_ID": 1007970,
"CurrentBPartnerValue": "MAROMA",
"CurrentBPartnerName": "MAROMA ADVERTISING SRL",
"CurrentBPartnerLocation_ID": 1007673,
"CurrentBPartnerLocation": "HARMAN",
"CurrentBPAddress": "STR. EREMIA GRIGORESCU, , , ",
"CurrentBPCounty": "HARMAN",
"CurrentBPRegion": "Brasov",
"CurrentUser_ID": 1008748,
"CurrentUser": "Max",
"CurrentUserEmail": null,
"CurrentUserPhone": null,
"ExtendedGuarantee": null,
"PostGuarantee": false,
"Lead_ID": 1000037,
"SystemStatus": "Production"
}