Skip to content

Instantly share code, notes, and snippets.

@IvanZelenskyy

IvanZelenskyy/req1.xml

Last active December 5, 2019 10:50
Show Gist options
  • Save IvanZelenskyy/be0146d8916290998170e8d339658c84 to your computer and use it in GitHub Desktop.
Save IvanZelenskyy/be0146d8916290998170e8d339658c84 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
{"requestId" : "353432", "indicator" : {"id": "M6_6_T1", "data" : [{"firstDayOfPeriod" : "2019-09-01", "periodСode" : "month", "orgId" : 4925, "error" : 0, "errorText" : "", "okved2" : "06", "region" : "87", "workers_average" : "4363.00", "workers_on_payroll_average" : "4363.00", "off_hour_workers_average" : "0.00", "civil_contract_workers_average" : "0.00", "salary_fund" : "421977.40", "on_payroll_salary_fund" : "421545.80", "off_hour_salary_fund" : "60.60", "civil_contracr_salary_fund" : "370.90"}, {"firstDayOfPeriod" : "2019-09-01", "periodСode" : "month", "orgId" : 4925, "error" : 0, "errorText" : "", "okved2" : "09.1", "region" : "87", "workers_average" : "1065.00", "workers_on_payroll_average" : "1064.00", "off_hour_workers_average" : "0.00", "civil_contract_workers_average" : "1.00", "salary_fund" : "142144.60", "on_payroll_salary_fund" : "137783.30", "off_hour_salary_fund" : "9.30", "civil_contracr_salary_fund" : "4352.10"}, {"firstDayOfPeriod" : "2019-09-01", "periodСode" : "month", "orgId" : 4925, "error" : 0, "errorText" : "", "okved2" : "06", "region" : "45", "workers_average" : "3.00", "workers_on_payroll_average" : "3.00", "off_hour_workers_average" : "0.00", "civil_contract_workers_average" : "0.00", "salary_fund" : "317.90", "on_payroll_salary_fund" : "317.90", "off_hour_salary_fund" : "0.00", "civil_contracr_salary_fund" : "0.00"}, {"firstDayOfPeriod" : "2019-09-01", "periodСode" : "month", "orgId" : 4925, "error" : 0, "errorText" : "", "okved2" : "06", "region" : "11100", "workers_average" : "1219.00", "workers_on_payroll_average" : "1219.00", "off_hour_workers_average" : "0.00", "civil_contract_workers_average" : "0.00", "salary_fund" : "137261.50", "on_payroll_salary_fund" : "137227.70", "off_hour_salary_fund" : "33.80", "civil_contracr_salary_fund" : "0.00"}, {"firstDayOfPeriod" : "2019-09-01", "periodСode" : "month", "orgId" : 4925, "error" : 0, "errorText" : "", "okved2" : "09.1", "region" : "11100", "workers_average" : "298.00", "workers_on_payroll_average" : "297.00", "off_hour_workers_average" : "1.00", "civil_contract_workers_average" : "0.00", "salary_fund" : "30198.20", "on_payroll_salary_fund" : "30013.50", "off_hour_salary_fund" : "184.70", "civil_contracr_salary_fund" : "0.00"} ] } }
Raw
req1.xml
{
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "object",
"properties": {
"ReqID": {
"title": "1",
"type": "string",
"minimum": 1
},
"SourceID": {
"title": "SAP_BW_GiD",
"type": "string"
},
"OrgList": {
"title": "1018",
"type": "array",
"minItems": 1,
"uniqueItems": true,
"items": {
"type": "number"
}
},
"KeyFig": {
"title": "ZKLSKF",
"description": "Идентификатор запрашиваемого показателя",
"type": "string"
},
"Code": {
"title": "month01102019",
"description": "Указывается код периода и первый день",
"type": "object",
"properties": {
"periodCode": {
"type": "string",
"enum": ["day", "week", "month", "quarter",
"half year", "year", "decade"
]
},
"FirstDay": {
"type": "string",
"format": "date-time"
}
}
}
},
"required": [
"ReqID",
"SourceID",
"KeyFig",
"Code"
]
}
@IvanZelenskyy
Copy link
Author

{
"ReqID": "32141242142",
"SourceID": "MSS_AKP",
"KeyFig": "M6_6_T1",
"Code": {
"periodCode": "month",
"FirstDay": "2019-09-01"
},
"OrgList": [
4925,
1083,
1689,
982
]
}

@IvanZelenskyy
Copy link
Author

{
"requestId": "32141242142",
"sourceId": "MSS_AKP",
"indicatorKey": "M6_6_T1",
"period": {
"periodCode": "month",
"firstDayOfPeriod": "2019-09-01"
},
"organisations": [
4925,
1083,
1689,
982
]
}

@IvanZelenskyy
Copy link
Author

curl -v -X POST -d '{"ReqID": "32141242142","SourceID": "MSS_AKP","KeyFig": "M6_6_T1","Code": {"periodCode": "month","FirstDay": "2019-09-01"},"OrgList": [4925,1083,1689,982]}' -H 'Content-type: application/json; utf-8' -u 'ESB_OGT:#{wBew8D' -v http://sapx62cidb.srv.lukoil.com/RESTAdapter/OGT/GetKeyFig

Note: Unnecessary use of -X or --request, POST is already inferred.

  • Trying 127.0.0.1...
  • TCP_NODELAY set
  • Connected to 127.0.0.1 (127.0.0.1) port 3128 (#0)
  • Server auth using Basic with user 'ESB_OGT'

POST http://sapx62cidb.srv.lukoil.com/RESTAdapter/OGT/GetKeyFig HTTP/1.1
Host: sapx62cidb.srv.lukoil.com
Authorization: Basic RVNCX09HVDoje3dCZXc4RA==
User-Agent: curl/7.60.0
Accept: /
Proxy-Connection: Keep-Alive
Content-type: application/json; utf-8
Content-Length: 155

  • upload completely sent off: 155 out of 155 bytes
    < HTTP/1.1 503 Service Unavailable
    < Via: 1.1 DB24-TMGPROXY04
    < Connection: close
  • HTTP/1.1 proxy connection set close!
    < Proxy-Connection: close
    < Date: Thu, 14 Nov 2019 13:57:24 GMT
    < Content-Type: text/html; charset=UTF-8
    < Proxy-Agent: IWSS
    < Cache-Control: no-cache
    <
<TITLE>503 Service Unavailable</TITLE>

503 Service Unavailable

Failed to resolve the name of server sapx62cidb.srv.lukoil.com * Closing connection 0

@IvanZelenskyy
Copy link
Author

curl -v -X POST -d '{"ReqID": "32141242142","SourceID": "MSS_AKP","KeyFig":"M6_6_T1","Period": {"Code": "month","FirstDay": "2019-09-01"},"OrgList": { "Org" : ["4925","1083","1689","982"]}}' -H 'Content-type: application/json; utf-8' -u 'ESB_OGT:#{wBew8D' -v http://sapx62cidb.srv.lukoil.com/RESTAdapter/OGT/GetKeyFig

@IvanZelenskyy
Copy link
Author

IvanZelenskyy commented Nov 15, 2019 •
edited
Loading

< Connection: close

  • HTTP/1.1 proxy connection set close!
    < Proxy-Connection: close
    < Date: Fri, 15 Nov 2019 10:51:45 GMT
    < Content-Type: text/html; charset=UTF-8
    < Proxy-Agent: IWSS
    < Cache-Control: no-cache
    <
<TITLE>504 Gateway Timeout</TITLE>

504 Gateway Timeout

Gateway timeout expired while waiting for server response * Closing connection 0 durdyevia@msk-ogt-t-web-1:~> curl -v -X POST -d '{"ReqID": "32141242142","SourceID": "MSS_AKP","KeyFig":"M6_6_T1","Period": {"Code": "month","FirstDay": "2019-09-01"},"OrgList": { "Org" : ["4925","1083","1689","982"]}}' -H 'Content-type: application/json; utf-8' -u 'ESB_OGT:#{wBew8D' -v http://10.202.130.12/RESTAdapter/OGT/GetKeyFig Note: Unnecessary use of -X or --request, POST is already inferred. * Uses proxy env variable no_proxy == 'localhost,127.0.0.1,dln4-lnxupd.srv.lukoil.com' * Uses proxy env variable http_proxy == 'http://127.0.0.1:3128' * Trying 127.0.0.1... * TCP_NODELAY set * Connected to 127.0.0.1 (127.0.0.1) port 3128 (#0) * Server auth using Basic with user 'ESB_OGT' > POST http://10.202.130.12/RESTAdapter/OGT/GetKeyFig HTTP/1.1 > Host: 10.202.130.12 > Authorization: Basic RVNCX09HVDoje3dCZXc4RA== > User-Agent: curl/7.60.0 > Accept: */* > Proxy-Connection: Keep-Alive > Content-type: application/json; utf-8 > Content-Length: 169 > * upload completely sent off: 169 out of 169 bytes < HTTP/1.1 504 Gateway Timeout < Via: 1.1 DB24-TMGPROXY04 < Connection: close * HTTP/1.1 proxy connection set close! < Proxy-Connection: close < Date: Fri, 15 Nov 2019 10:54:18 GMT < Content-Type: text/html; charset=UTF-8 < Proxy-Agent: IWSS < Cache-Control: no-cache < <TITLE>504 Gateway Timeout</TITLE>

504 Gateway Timeout

Gateway timeout expired while waiting for server response * Closing connection 0 durdyevia@msk-ogt-t-web-1:~>

@IvanZelenskyy
Copy link
Author

POST http://10.202.130.12/RESTAdapter/OGT/GetKeyFig HTTP/1.1
Authorization: Basic RVNCX09HVDoje3dCZXc4RA==
User-Agent: curl/7.60.0
Accept: /
Content-type: application/json; utf-8
Content-Length: 169
{"ReqID": "32141242142","SourceID": "MSS_AKP","KeyFig":"M6_6_T1","Period": {"Code": "month","FirstDay": "2019-09-01"},"OrgList": { "Org" : ["4925","1083","1689","982"]}}

@IvanZelenskyy
Copy link
Author

PS C:\Users\DurdyevIA\Documents> Invoke-RestMethod -Method 'Post' -Uri 'http://10.202.194.129/integration/lukoil/saveInd
icatorData' -InFile .\body.json -Headers @{'Content-Type'='application/json'}

@IvanZelenskyy
Copy link
Author

{
"ReqID":"123456789",
"SourceID":"SAP_BW_GiD",
"KeyFig":"ZKLSKF",
"Period":{
"Code":"month",
"FirstDay":"2019-08-01"
},
"OrgList":{
"Org":[
"0002165442",
"0000001083"
]
}
}

@IvanZelenskyy
Copy link
Author

{"requestId":"123456789","indicator":{"id":"ZKLSKF","data":[{"firstDayOfPeriod":"20190801","periodСode":"month","orgId":1083,"error":0,"errorText":"","ZKLSKF":"1.0000000000000000E+00","ZVSKVPROD":"0000000008","Z3SKVPPRO":"0000000000","ZCTRSRV":"0000000000","ZINDLKSKV":"2","ZINDRSTR":"0","ZWELLPURP":"0000000014","Z3SKVSOST":"0000000005","ZSOSTSKV":"0000000002","ZWELLOPER":"0000000000","ZOILFIELD__ZGEOSTR":"0000000000"},{"firstDayOfPeriod":"20190801","periodСode":"month","orgId":2165442,"error":0,"errorText":"","ZKLSKF":"1.0000000000000000E+00","ZVSKVPROD":"0000000008","Z3SKVPPRO":"0000000000","ZCTRSRV":"0000000000","ZINDLKSKV":"0","ZINDRSTR":"0","ZWELLPURP":"0000000014","Z3SKVSOST":"0000000032","ZSOSTSKV":"0000000002","ZWELLOPER":"0000000000","ZOILFIELD__ZGEOSTR":"0000000001"}]}})

@IvanZelenskyy
Copy link
Author

http://10.202.194.129/settings/nsi/objects/pokazateli_dlya_form_sbora/zklskf

@IvanZelenskyy
Copy link
Author

{
"ReqID":"123456789",
"SourceID":"MSS_AKP",
"KeyFig":"M6_5_T1",
"Period":{
"Code":"month",
"FirstDay":"2019-09-01"
},
"OrgList":{
"Org":[
"0002165442",
"0000001083"
]
}
}

@IvanZelenskyy
Copy link
Author

{
"ReqID":"123456789",
"SourceID":"MSS_AKP",
"KeyFig":"M6_6_T1",
"Period":{
"Code":"month",
"FirstDay":"2019-09-01"
},
"OrgList":{
"Org":[
"0002165442",
"0000001083"
]
}
}

@IvanZelenskyy
Copy link
Author

{
"ReqID":"987654321",
"SourceID":"MSS_AKP",
"KeyFig":"M6_1_T1",
"Period":{
"Code":"year",
"FirstDay":"2019-01-01"
},
"OrgList":{
"Org":[
"2165442",
"1083"
]
}
}

@IvanZelenskyy
Copy link
Author

{
"ReqID":"987654321",
"SourceID":"MSS_AKP",
"KeyFig":"M6_1_T1",
"Period":{
"Code":"year",
"FirstDay":"2019-01-01"
},
"OrgList":{
"Org":[
"0002165442",
"0000001083"
]
}
}

@IvanZelenskyy
Copy link
Author

{
"ReqID":"987654321",
"SourceID":"MSS_AKP",
"KeyFig":"M6_1_T1",
"Period":{
"Code":"year",
"FirstDay":"2019-01-01"
},
"OrgList":{
"Org":[
"0000001007",
"0000001083"
]
}
}

@IvanZelenskyy
Copy link
Author

{
"ReqID":"234567891",
"SourceID":"MSS_AKP",
"KeyFig":"M6_5_T1",
"Period":{
"Code":"month",
"FirstDay":"2019-10-01"
},
"OrgList":{
"Org":[
"0000001007",
"0000001083"
]
}
}

@IvanZelenskyy
Copy link
Author

curl -H 'Content-type: application/json; utf-8' -X POST -d '{"requestId" : "124667555", "indicator" : {"id": "ZKLSKF", "data" : [{"firstDayOfPeriod" : "20190801", "periodCode" : "month", "orgId" : 1083, "error" : 0, "errorText" : "", "ZKLSKF" : "0.0000000000000000E+00", "ZVSKVPROD" : "0000000000", "Z3SKVPPRO" : "0000000000", "ZCTRSRV" : "0000000000", "ZINDLKSKV" : "0", "ZINDRSTR" : "0", "ZWELLPURP" : "0000000000", "Z3SKVSOST" : "0000000000", "ZSOSTSKV" : "0000000000", "ZWELLOPER" : "0000000000", "ZOILFIELD__ZGEOSTR" : "0000000000"} ] } } ' http://localhost:9090/integration/lukoil/saveIndicatorData -v

@IvanZelenskyy
Copy link
Author

com.gost_group.nsi.controller.integration.FormIntegrationController: Exception while saveFi
nalIndicatorData({"requestId":"111404985","indicator":{"id":"M6_1_T5555","data":[{"firstDayOfPeriod":"2019-01-01","periodСode":"year","orgId":982,"error":1,"errorTe
xt":"Показатель (M6_1_T5555) не определён. Проверьте верность указания наименование показателя"}]}})

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment