Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2017
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.05 KB | None | 0 0
  1. [
  2. {
  3. "complemento": {
  4. "valorTotal": 24.9
  5. },
  6. "dets": [
  7. {
  8. "nItem": "1",
  9. "prod": {
  10. "indTot": "1",
  11. "qCom": 1.0,
  12. "uCom": "UN",
  13. "vProd": 3.5,
  14. "vUnCom": 3.5,
  15. "xProd": "AGUA"
  16. }
  17. },
  18. {
  19. "nItem": "2",
  20. "prod": {
  21. "indTot": "1",
  22. "qCom": 0.312,
  23. "uCom": "KG",
  24. "vProd": 21.4,
  25. "vUnCom": 68.6,
  26. "xProd": "BUFFET"
  27. }
  28. }
  29. ],
  30. "emit": {
  31. "cnpj": "01.234.567/0001-89",
  32. "enderEmit": {
  33. "fone": "1-650-933-4902",
  34. "xBairro": "",
  35. "xLgr": "650 Castro St. unit 210",
  36. "xMun": "Mountain View",
  37. "xPais": "United States",
  38. "uf": "CA"
  39. },
  40. "xFant": "TOTVS Labs"
  41. },
  42. "ide": {
  43. "dhEmi": {
  44. "$date": "2016-01-05T12:01:54.000Z"
  45. },
  46. "natOp": "VENDA"
  47. },
  48. "infAdic": {
  49. "infCpl": "Mesa 2"
  50. },
  51. "total": {
  52. "icmsTot": {
  53. "vDesc": 0.0,
  54. "vFrete": 0.0,
  55. "vOutro": 0.0,
  56. "vProd": 24.9,
  57. "vSeg": 0.0,
  58. "vTotTrib": 2.53,
  59. "vbc": 0.0,
  60. "vbcst": 0.0,
  61. "vcofins": 0.0,
  62. "vicms": 0.0,
  63. "vicmsDeson": 0.0,
  64. "vii": 0.0,
  65. "vipi": 0.0,
  66. "vnf": 24.9,
  67. "vpis": 0.0,
  68. "vst": 0.0
  69. }
  70. },
  71. "versaoDocumento": 1.0
  72. }
  73. ,{
  74. "complemento": {
  75. "valorTotal": 92.53
  76. },
  77. "dets": [
  78. {
  79. "nItem": "1",
  80. "prod": {
  81. "indTot": "1",
  82. "qCom": 1.218,
  83. "uCom": "KG",
  84. "vProd": 83.55,
  85. "vUnCom": 68.6,
  86. "xProd": "BUFFET"
  87. }
  88. },
  89. {
  90. "nItem": "2",
  91. "prod": {
  92. "indTot": "1",
  93. "qCom": 2.0,
  94. "uCom": "UN",
  95. "vProd": 9.0,
  96. "vUnCom": 4.5,
  97. "xProd": "REFRIGERANTE"
  98. }
  99. }
  100. ],
  101.  
  102. json.matchData <- fromJSON("sample.txt")
  103. head(json.matchData)
  104. matchData.i <- lapply(json.matchData$dets, function(x){unlist(x)})
  105. matchData <- rbind.fill(lapply(matchData.i,
  106. function(x) do.call("data.frame", as.list(x))
  107. ))
  108. matchData <- do.call("rbind", matchData.i)
  109. matchData <- as.data.frame(matchData)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement