cli:franke:erp_integration_next_rest

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
cli:franke:erp_integration_next_rest [2022/04/27 16:06]
m.zingaretti 		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' 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 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 66: Line 66:
  
 <code sql> <code sql>
 +--- drop table sapinfoubi
 +
 CREATE TABLE public.sapinfoubi ( CREATE TABLE public.sapinfoubi (
     codop character varying(51) NOT NULL,     codop character varying(51) NOT NULL,
     codubi character varying(51) NOT NULL,     codubi character varying(51) NOT NULL,
-    confgrp character varying(51)+    confgrp character varying(51), 
 +    ordope character varying(51)
 ); );
  
 COMMENT ON TABLE public.sapinfoubi IS 'Tabella informazioni codop-codubi arrivate da SAP'; 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.codop IS 'Rueck Ricevuto da sap';
-COMMENT ON COLUMN public.sapinfoubi.codubi IS 'codice postaizone';+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.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 sapinfoubi_pkey PRIMARY KEY (codop, codubi);
Line 81: Line 85:
 ALTER TABLE ONLY public.sapinfoubi ADD CONSTRAINT ix_sapinfoubi_codubi FOREIGN KEY (codubi) REFERENCES public.ubicaz(codice) 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> </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)
 +
 +
  • cli/franke/erp_integration_next_rest.1651068416.txt.gz
  • Last modified: 2022/04/27 16:06
  • by m.zingaretti