Histórico da Página

{
	"name": "WTA -Buscar Pis/CofinsImposto NCM",
	"request": {
		"method": "GET",
		"header": [
			{
				"key": "Authorization",
				"value": "Bearer {{TOKEN}}"
			},
			{
				"key": "Accept",
				"value": "*/*"
			}
		],
		"url": {
			"raw": "{{URL_BASE}}/winthor/tributacao/v0/saida/piscofinsncm/consultar",
			"query": [
				{
					"key": "tamanhopageSize",
					"value": "{{PAGE_SIZE}}"
				},
				{
					"key": "paginapage",
					"value": "{{PAGE}}"
				},
				
				 ,
        {
					"key": "ultAlterdataUltimaALteracao",
					"value": "{{LAST_CHANGE}}"
				}
			]
		}
	},
	"response": []
}

[
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "items": {
        "*": {
          "CEMcodigoNcm_": 100,
          "idExterno": "=concatsplit('pdvsync-piscofins-\\.', @(1,codTribPisCofins),'-', @(1,dtUltAlt))",
          /* JOLT não possui uma função nativa para multiplicar valores. */
          /* mas tem como multiplicar usando dessa forma: */
 codigoNcm))",
         /* https://intercom.help/godigibee/en/articles/4239806-transformations-with-jolt */
          "valorInverso"codigo_Ncm": "=dividejoin(1'', @(1,CEMcodigoNcm_))",
          "aliquotaPisPercentualidExterno": "=divideAndRound(4concat('pdvsync-ncm-', @(1,aliquotaPisid),'-', @(1,valorInversodataUltimaAtualizacao))",
          "aliquotaCofinsPercentualaliquotaImportada": "=divideAndRound(4, @(1,aliquotaCofins), @(1,valorInverso))",
          /* Percentuais para string */"aliquotaMunicipal": "",
          "aliquotaPisPercentualStrchave": "=toString(@(1,aliquotaPisPercentual))"null,
          "aliquotaCofinsPercentualStrfonte": "=toString(@(1,aliquotaCofinsPercentual))"null,
          /* Separar as casas decimais pelo o '.' para remover o ponto*/"situacao": 1
        }
      }
    }
	},
  {
    "aliquotaPisPercentualArroperation": "=split('\\.',@(1,aliquotaPisPercentualStr))shift",
    "spec": {
      "aliquotaCofinsPercentualArritems": "=split('\\.',@(1,aliquotaCofinsPercentualStr))",{
          /*Juntar as casas decimais usando virgula*/"*": {
          "aliquotaPisidExterno": "=join(',', @(1,aliquotaPisPercentualArr))idExterno[&1]",
          "aliquotaCofinsid": "=join(',', @(1,aliquotaCofinsPercentualArr))"items[&1].[0].idRetaguarda",
        }
      }
 "codigo_Ncm": "items[&1].[0].codigoNcm",
   }
  },
  {
    "operationcodigoExcecao": "shiftitems[&1].[0].codigoExcecao",
    "spec": {
     "aliquotaNacional": "items": {
[&1].[0].aliquotaNacional",
          "*aliquotaEstadual": {"items[&1].[0].aliquotaEstadual",
          "idExternocodigoCest": "idExternoitems[&1].[0].codigoCest",
          "cstaliquotaImportada": ["items[&1].[0].cstPisaliquotaImportada",
          "aliquotaMunicipal": "items[&1].[0].cstCofinsaliquotaMunicipal"],
          "aliquotaPischave": "items[&1].[0].aliquotaPischave",
          "aliquotaCofinsfonte": "items[&1].[0].aliquotaCofinsfonte",
          "codTribPisCofinssituacao": "items[&1].[0].idRetaguardasituacao"
        }
      }
    }
	},
  {
    "operation": "default",
    "spec": {
      "_attr_access": "items",
      "items[]": {
        "*[]": {
          "*": {
            "idInquilino": "{{ID_INQUILINO}}",
            "idProprietario": "{{MASTER_ID_PROPRIETARIO}}",
            "loteOrigem": "{{LOTE_ORIGEM}}",
            "situacao": 1
          }
        }
      }
    }
  }
]

{
	"name": "Enviar Pis/Cofins",
	"request": {
		"method": "POST",
		"header": [
			{
				"key": "Accept",
				"value": "*/*"
			},
			{
				"key": "Content-Type",
				"value": "application/json"
			}
		],
		"url": {
			"raw": "{{URL_ENVIAR_PIS_COFINS}}",
			"query": []
		},
		"bodyraw": {{CLIENT_JSON}}
	}
}

[
	{
		"operation": "default",
		"spec": {
			"status": 2
		}
	}
]