Differences

This shows you the differences between two versions of the page.

--- cli:franke:erp_integration_next_rest [2022/04/26 09:33]
n.bergantino
+++ cli:franke:erp_integration_next_rest [2024/04/23 15:17] (current)
m.zingaretti [gestione ConfirmationGroup]
@@ Line 23: / Line 23: @@
 curl --request GET 'https://franke.prod.apimanagement.eu10.hana.ondemand.com/a88a/NEXTOEE/API_PROD_ORDER/ProductionOrder/1000001' --header 'APIKey: API' --header 'Authorization: Bearer TOKEN'
-#falshback
+#flashback
 curl --request POST 'https://franke.prod.apimanagement.eu10.hana.ondemand.com:443/a88a/NEXTOEE/API_PROD_ORDER/ConfirmProductionOrder/1000007' --header 'APIKey: API' --header 'Authorization: Bearer TOKEN' --header 'Content-Type: application/json' --data-raw '{ "ConfirmationDate": "2022-01-24T00:00:00","ManufacturingOrder": "1000007", "YieldQuantity": "0",  "ProductionUnit": "PC", "FinalConfirmatio
@@ Line 61: / Line 61: @@
 </xnetagents>
 </code>
+====== gestione ConfirmationGroup ======
+La tabella sapinfoubi prende infomazioni riguardo il rueck (codop) e postazione (postazione) da inviare con il metodo POST per il Flashing Back
+<code sql>
+--- drop table sapinfoubi
+CREATE TABLE public.sapinfoubi (
+    codop character varying(51) NOT NULL,
+    codubi character varying(51) NOT NULL,
+    confgrp character varying(51),
+    ordope character varying(51)
+);
+COMMENT ON TABLE public.sapinfoubi IS 'Tabella informazioni codop-codubi arrivate da SAP';
+COMMENT ON COLUMN public.sapinfoubi.codop IS 'Rueck Ricevuto da sap';
+COMMENT ON COLUMN public.sapinfoubi.codubi IS 'codice postazione';
+COMMENT ON COLUMN public.sapinfoubi.confgrp IS 'ConfirmationGroup da inviare con il flashingback';
+COMMENT ON COLUMN public.sapinfoubi.ordope IS 'OrderOperation da inviare con il flashingback';
+ALTER TABLE ONLY public.sapinfoubi ADD CONSTRAINT sapinfoubi_pkey PRIMARY KEY (codop, codubi);
+ALTER TABLE ONLY public.sapinfoubi ADD CONSTRAINT ix_sapinfoubi_codop FOREIGN KEY (codop) REFERENCES public.ordprod(codop) ON UPDATE CASCADE ON DELETE CASCADE;
+ALTER TABLE ONLY public.sapinfoubi ADD CONSTRAINT ix_sapinfoubi_codubi FOREIGN KEY (codubi) REFERENCES public.ubicaz(codice) ON UPDATE CASCADE ON DELETE CASCADE;
+</code>
+====== Crezione API ======
+Generazione API, Avere Get a SAP Universal ID se manca crearlo dalla schermata di accesso \\
+{{:cli:franke:pasted:20230329-085345.png?600}} \\
+{{:cli:franke:pasted:20230329-085352.png?600}}
+Una volta entrato da questo link: \\  \\
+https://frankeisprod.apibhubenterprise.cfapps.eu10.hana.ondemand.com/product/PRD_NEXTOEE \\ \\
+Creare una nuova app: \\ \\
+{{:cli:franke:pasted:20230329-085651.png?600}} \\
+{{:cli:franke:pasted:20230329-085925.png?600}} \\
+Usare queste nell'agente Rest (AgentRestSAP)