Embedded Files
Interface
It allows you:
to view Bank Statement Line (detail)
to insert new Bank Statement Line (detail)
to update Bank Statement Line (detail) - only for Document in Draft
to delete Bank Statement Line (detail) - only for Document in Draft
Prerequisites:
In order to use this API Method for inserting or updating data there must be accomplished the following requirements in SocrateCloud:
to have an active Bank Statement (master)
Columns that can be used as filters:
BankStatement_ID
Line
Actions that can be done:
list
create
update
delete
Bank Statement Line fields (Detail)
In SocrateCloud, a Bank Statement Line has the following structure:
API Methods:
List
URL: https://api.socratecloud.com/webapi/rest/bank/statement/line/list/{version}?startRow={0}&endRow={100}&accessToken={access_token}
Method: GET
Available filter parameters:
BankStatement_ID
Line
Return: JSON object with next format:
"data":[
{
"Organization_ID":123456,
"OrganizationValue":"Org Test",
"Organization":"Org Test",
"Created":"2023-02-05 00:00:00+0000",
"CreatedBy_ID":1234,
"CreatedBy":"User Test",
"Updated":"2023-02-05 00:00:00+0000",
"UpdatedBy_ID":1234,
"UpdatedBy":"User Test",
"Line":10,
"Description":"Test Description",
"StatementLineDate":"2023-02-05 00:00:00+0000",
"DateAcct":"2023-02-05 00:00:00+0000",
"ValutaDate":"2023-02-05 00:00:00+0000",
"StmtAmt":12,
"TrxAmt":10,
"InterestAmt":-2,
"BPartner_ID":54321,
"BPartnerValue":"Tert Test",
"BPartnerName":"Tert Test",
"Currency_ID":123,
"ConversionType_ID":321,
"ConversionTypeValue":"S",
"ConversionTypeName":"Spot",
"Invoice_ID":1234,
"InvoiceNo":"Test Invoice",
"Order_ID":12345,
"OrderNo":"Test Order",
"Payment_ID":6543,
"PaymentNo":"6543",
"ChargeAmt":4,
"Charge_ID":65432,
"ChargeName":"Avans",
"SAFT_TaxType_ID":12345,
"SAFT_TaxType_Value":"Test TaxType",
"SAFT_TaxType_Name":"Test TaxType",
"SAFT_Tax_ID":2345,
"SAFT_Tax_Value":"Test Tax",
"SAFT_Tax_Name":"Test Tax",
"SAFT_TaxPercentage":15,
"SAFT_TaxBaseAmt":5,
"TrxOrganization_ID":654321,
"TrxOrganizationValue":"Test Organization",
"TrxOrganization":"Test Organization",
"Project_ID":34567,
"ProjectValue":"Test Project",
"ProjectName":"Test Project",
"ProjectPhase_ID":4567,
"ProjectPhase":"Test Phase",
"ProjectTask_ID": 1005872,
"ProjectTask":"Test API",
"Activity_ID":5432,
"ActivityValue":"Test Activity",
"Activity":"Test Activity",
"Campaign_ID":98765,
"CampaignValue":"Test Campaign",
"CampaignName":"Test Campaign",
"Asset_ID":87654,
"AssetValue":"Test Asset",
"Asset":"Test Asset"
}
],
"totalRows":1
}
Create
URL: https://api.socratecloud.com/webapi/rest/bank/statement/line/create/{version}?accessToken={access_token}
Method: POST
The Parameters are mandatory:
BankStatement_ID or: 'Bank Account' (BankAccount_ID or IBAN or AccountNo) and StatementDate and Name
In the content are mandatory:
Organization_ID or OrganizationValue or Organization
Return an object with "data" and "id" for success or error message (starts with "Error:"). Where "data" is Line number of Bank Statement Line and "id" is Bank Statement ID.
Example for success message:
{
"data": "10",
"id": 12345
}
Example for error message:
{
"errorMessage": "No JSON content found",
"isError": true,
"errorCode": 0
}
Data format:
{
"Organization_ID":123456,
"OrganizationValue":"Org Test",
"Organization":"Org Test",
"Description":"Test Description",
"StatementLineDate":"2023-02-05 00:00:00+0000",
"DateAcct":"2023-02-05 00:00:00+0000",
"ValutaDate":"2023-02-05 00:00:00+0000",
"StmtAmt":12,
"TrxAmt":10,
"InterestAmt":-2,
"BPartner_ID":54321,
"BPartnerValue":"Tert Test",
"BPartnerName":"Tert Test",
"Currency_ID":123,
"ConversionType_ID":321,
"ConversionTypeValue":"S",
"ConversionTypeName":"Spot",
"Invoice_ID":1234,
"InvoiceNo":"Test Invoice",
"Order_ID":12345,
"OrderNo":"Test Order",
"Payment_ID":6543,
"PaymentNo":"6543",
"ChargeAmt":4,
"Charge_ID":65432,
"ChargeName":"Avans",
"SAFT_TaxType_ID":12345,
"SAFT_TaxType_Value":"Test TaxType",
"SAFT_TaxType_Name":"Test TaxType",
"SAFT_Tax_ID":2345,
"SAFT_Tax_Value":"Test Tax",
"SAFT_Tax_Name":"Test Tax",
"SAFT_TaxPercentage":15,
"SAFT_TaxBaseAmt":5,
"TrxOrganization_ID":654321,
"TrxOrganizationValue":"Test Organization",
"TrxOrganization":"Test Organization",
"Project_ID":34567,
"ProjectValue":"Test Project",
"ProjectName":"Test Project",
"ProjectPhase_ID":4567,
"ProjectPhase":"Test Phase",
"ProjectTask_ID": 1005872,
"ProjectTask":"Test API",
"Activity_ID":5432,
"ActivityValue":"Test Activity",
"Activity":"Test Activity",
"Campaign_ID":98765,
"CampaignValue":"Test Campaign",
"CampaignName":"Test Campaign",
"Asset_ID":87654,
"AssetValue":"Test Asset",
"Asset":"Test Asset"
}
Update
URL: https://api.socratecloud.com/webapi/rest/bank/statement/line/update/{version}?accessToken={access_token}
Method: POST
The Parameters are mandatory:
BankStatement_ID or: 'Bank Account' (BankAccount_ID or IBAN or AccountNo) and StatementDate and Name
Line (number of Bank Statement Line)
In the content are mandatory:
Organization_ID or OrganizationValue or Organization
StatementLineDate, DateAcct, ValutaDate
TrxAmt, InterestAmt, ChargeAmt
Currency_ID
Charge_ID or ChargeName is mandatory if the value of ChargeAmt is different from 0
Return an object with "data" and "id" for success or error message (starts with "Error:"). Where "data" is Line number of Bank Statement Line and "id" is Bank Statement ID.
Example for success message:
{
"data": "10",
"id": 12345
}
Example for error message:
{
"errorMessage": "Bank Statement Processed",
"isError": true,
"errorCode": 0
}
Data format:
{
"Organization_ID":123456,
"OrganizationValue":"Org Test",
"Organization":"Org Test",
"Description":"Test Description",
"StatementLineDate":"2023-02-05 00:00:00+0000",
"DateAcct":"2023-02-05 00:00:00+0000",
"ValutaDate":"2023-02-05 00:00:00+0000",
"StmtAmt":12,
"TrxAmt":10,
"InterestAmt":-2,
"BPartner_ID":54321,
"BPartnerValue":"Tert Test",
"BPartnerName":"Tert Test",
"Currency_ID":123,
"ConversionType_ID":321,
"ConversionTypeValue":"S",
"ConversionTypeName":"Spot",
"Invoice_ID":1234,
"InvoiceNo":"Test Invoice",
"Order_ID":12345,
"OrderNo":"Test Order",
"Payment_ID":6543,
"PaymentNo":"6543",
"ChargeAmt":4,
"Charge_ID":65432,
"ChargeName":"Avans",
"SAFT_TaxType_ID":12345,
"SAFT_TaxType_Value":"Test TaxType",
"SAFT_TaxType_Name":"Test TaxType",
"SAFT_Tax_ID":2345,
"SAFT_Tax_Value":"Test Tax",
"SAFT_Tax_Name":"Test Tax",
"SAFT_TaxPercentage":15,
"SAFT_TaxBaseAmt":5,
"TrxOrganization_ID":654321,
"TrxOrganizationValue":"Test Organization",
"TrxOrganization":"Test Organization",
"Project_ID":34567,
"ProjectValue":"Test Project",
"ProjectName":"Test Project",
"ProjectPhase_ID":4567,
"ProjectPhase":"Test Phase",
"ProjectTask_ID": 1005872,
"ProjectTask":"Test API",
"Activity_ID":5432,
"ActivityValue":"Test Activity",
"Activity":"Test Activity",
"Campaign_ID":98765,
"CampaignValue":"Test Campaign",
"CampaignName":"Test Campaign",
"Asset_ID":87654,
"AssetValue":"Test Asset",
"Asset":"Test Asset"
}
Delete
URL: https://api.socratecloud.com/webapi/rest/bank/statement/line/delete/{version}?accessToken={access_token}
Method: POST
The Parameters are mandatory:
BankStatement_ID or: 'Bank Account' (BankAccount_ID or IBAN or AccountNo) and StatementDate and Name
Line (number of Bank Statement Line)
Return: "Deleted" for success or error message (starts with "Error: ").
Page updated
Report abuse