interchange data to a json api.

[nikoslantos]

Hi my name is nick.
and i need to interchange data ( edi invoices ) with a software provider named softone here in Greece.
My application is msaccess 2002 (mdb file) . Does any one can help me with this isue.
i can pay for this in logical price.
thank you.

 

[nikoslantos]

The data interchange it will be with json file format.

 

[arnelgp]

show your sample json file.

 

[nikoslantos]

{
"Currency":"EURO",
"CurrencyCode":"EUR",
"InvoiceTypeCode":"1.1",
"DocumentType":"(72)Τιμολόγιο Δελτίο Αποστολής",
"DocumentTypeCode":"INVOICE",
"Series":"Γ",
"Number":"122233",
"DateIssued":"2021-10-05T10:32:41",
"Issuer":{
"RegisteredName":"ΜΟΥΡΚΑ Ι.Κ.Ε",
"Vat":"EL118058830",
"Activities":[
"SUPER MARKET"
],
"Phones":[
"2632024094"
],
"Address":{
"Country":"Greece",
"CountryCode":"GR",
"City":"ΥΠΟΚΑΤΑΣΤΗΜΑ ΑΙΤΩΛΙΚΟΥ",
"Street":"ΝΤΟΛΜΑ 4",
"Postal":"30400"
},
"TaxOffice":"ΜΕΣΟΛΟΓΓΙΟΥ"
},
"CounterParty":{
"RegisteredName":"ΕΣΤΙΑΤΟΡΙΟ ΠΑΠΑΓΡΗΓΟΡΑΤΟΣ",
"Vat":"EL048147244",
"Activities":[
"Εστιατοριο"
],
"Address":{
"CountryCode":"GR",
"Country":"Greece",
"City":"Missing",
"Street":"Missing",
"Postal":"30400"
}
},
"DistributionDetails":{
"InternalDocumentId":"Internal erp Code",
"MovePurpose":"ΠΩΛΗΣΗ",
"DeliveryDestinationDetails":{
"Address":{
"CountryCode":"GR",
"Country":"Greece",
"Street":"ΕΔΡΑ ΤΟΥΣ",
"Postal":"Missing",
"City":"Missing"
}
}
},
"PaymentDetails":{
"PaymentMethods":[
{
"PaymentMethodType":"ΜΕΤΡΗΤΟΙΣ",
"PaymentMethodTypeCode":3,
"Amount":19.65
}
]
},
"AdditionalDetails": {
"AccountingDepartmentEmails": [
"to_email_pou_tha_lavei_eidopoihsh@mail.com"
]
},
"Details":[
{
"Code":"5202453030626",
"Descriptions":[
"MR BREAKFAST ΔΗΜΗΤΡΙΑΚΑ RING HONEY 375G"
],
"MeasurementUnit":"ΤEM",
"Quantity":1,
"UnitPrice":1.58,
"NetTotal":1.58,
"Total":1.79,
"VATTotal":0.21,
"VatCategoryCode":2,
"IncomeClassification":{
"ClassificationTypeCode":"E3_561_001",
"ClassificationCategoryCode":"",
"Amount":1.58
}
},
{
"Code":"9008695420425",
"Descriptions":[
"IGLO ΦΙΛΕΤΟ ΜΠΑΚΑΛΙΑΡΟΥ 240ΓΡ Σ8"
],
"MeasurementUnit":"τεμ",
"Quantity":1,
"UnitPrice":4.25,
"NetTotal":4.25,
"Total":4.8,
"VATTotal":0.55,
"VatCategoryCode":2,
"IncomeClassification":{
"ClassificationTypeCode":"E3_561_001",
"ClassificationCategoryCode":"",
"Amount":4.25
}
},
{
"Code":"8001090026897",
"Descriptions":[
"LENOR ΜΑΛΑΚ 26 ΜΕΖ DIAMANTE K FIORI DI L"
],
"MeasurementUnit":"τεμ",
"Quantity":1,
"UnitPrice":2.73,
"NetTotal":2.73,
"Total":3.39,
"VATTotal":0.66,
"VatCategoryCode":1,
"IncomeClassification":{
"ClassificationTypeCode":"E3_561_001",
"ClassificationCategoryCode":"",
"Amount":2.73
}
},
{
"Code":"521034048401",
"Descriptions":[
"PUMMARO ΨΙΛΟΚΟΜΜΕΝΟ ΚΛΑΣΣΙΚΟ 400ΓΡ Χ24Τ"
],
"MeasurementUnit":"τεμ",
"Quantity":1,
"UnitPrice":0.69,
"NetTotal":0.69,
"Total":0.78,
"VATTotal":0.09,
"VatCategoryCode":2,
"IncomeClassification":{
"ClassificationTypeCode":"E3_561_001",
"ClassificationCategoryCode":"",
"Amount":0.69
}
},
{
"Code":"5210113000964",
"Descriptions":[
"ΕΛΛ.ΜΑΡΚΕΤ ΣΑΚ.ΤΥΠΩΜ.35Χ35(40μικ)"
],
"MeasurementUnit":"ΚΙΛ",
"Quantity":2,
"UnitPrice":0.12,
"NetTotal":0.24,
"Total":0.3,
"VATTotal":0.06,
"VatCategoryCode":1,
"IncomeClassification":{
"ClassificationTypeCode":"E3_561_001",
"ClassificationCategoryCode":"",
"Amount":0.24
}
},
{
"Code":"5201013014618",
"Descriptions":[
"SYN ΖΥΜ.ΣΠΑΓΓΕΤΙ Νο10 500γρ σ24"
],
"MeasurementUnit":"Τεμ",
"Quantity":1,
"UnitPrice":0.45,
"NetTotal":0.45,
"Total":0.51,
"VATTotal":0.06,
"VatCategoryCode":2,
"IncomeClassification":{
"ClassificationTypeCode":"E3_561_001",
"ClassificationCategoryCode":"",
"Amount":0.45
}
},
{
"Code":"5201013014618",
"Descriptions":[
"SYN ΖΥΜ.ΣΠΑΓΓΕΤΙ Νο10 500γρ σ24"
],
"MeasurementUnit":"Τεμ",
"Quantity":1,
"UnitPrice":0.45,
"NetTotal":0.45,
"Total":0.51,
"VATTotal":0.06,
"VatCategoryCode":2,
"IncomeClassification":{
"ClassificationTypeCode":"E3_561_001",
"ClassificationCategoryCode":"",
"Amount":0.45
}
},
{
"Code":"5206783000489",
"Descriptions":[
"ΕΛ ΦΑΣΟΛΑΚΙ ΠΛΑΤΥ ΚΑΤΕΨ. 100ΓΡ Σ10"
],
"MeasurementUnit":"Τεμ",
"Quantity":1,
"UnitPrice":1.95,
"NetTotal":1.95,
"Total":2.2,
"VATTotal":0.25,
"VatCategoryCode":2,
"IncomeClassification":{
"ClassificationTypeCode":"E3_561_001",
"ClassificationCategoryCode":"",
"Amount":1.95
}
},
{
"Code":"5201168715217",
"Descriptions":[
"ΔΩΔΩΝΗ ΓΙΑΟΥΡΤΙ ΚΛΑΣΙΚΟ 1ΚΙΛ.2%Λ.ΠΛ.ΔΟΧ."
],
"MeasurementUnit":"Τεμ",
"Quantity":1,
"UnitPrice":3,
"NetTotal":3,
"Total":3.39,
"VATTotal":0.39,
"VatCategoryCode":2,
"IncomeClassification":{
"ClassificationTypeCode":"E3_561_001",
"ClassificationCategoryCode":"",
"Amount":3
}
},
{
"Code":"5204458016445",
"Descriptions":[
"ΕΛΟΜΑΣ ΤΥΡΟΠΙΤΑΚΙ 800ΓΡ Σ10"
],
"MeasurementUnit":"Τεμ",
"Quantity":1,
"UnitPrice":1.76,
"NetTotal":1.76,
"Total":1.99,
"VATTotal":0.23,
"VatCategoryCode":2,
"IncomeClassification":{
"ClassificationTypeCode":"E3_561_001",
"ClassificationCategoryCode":"",
"Amount":1.76
}
}
],
"VatAnalysis":[{
"Name":"24%",
"VatAmount":0.72,
"UnderlyingValue": 3.69,
"Percentage": 24
},
{
"Name":"13%",
"VatAmount":1.84,
"UnderlyingValue": 15.97,
"Percentage": 13
}],
"Summaries":{
"TotalNetAmount":17.1,
"TotalVATAmount":2.56,
"TotalGrossValue":19.66,
"TotalPayableAmount":19.66
}
}

 

[nikoslantos]

i can create this data from my database as a json file .
But i don't know how can post it to provider wich have the api.
and then to get the mark of it.

 

[nikoslantos]

i have found this script

 

[nikoslantos]

i can't post the vb code but i can send you as a file
if it helps

 

[nikoslantos]

thank you !

 

[arnelgp]

you need to communicate with softone on how
to use their api. and if ever possible to use vba.

 

[isladogs]

HI @nikoslantos
For info, I've replied to your PM

 

[theDBguy]

Hi Nick. Welcome to AWF!

Can you post a link to their API website?

 

[arnelgp]

For info, I've replied to your PM

you might get it FREE here.