Daily extract of item status with service layer

[former_member590735]

Good morning I would like to know if someone has already extract item status from SAP B1 with the service layer.

My wish is to have a daily extract of each item with his status.

[former_member590735]

It's ok sorry. I have now to create a Service layer package to schedule it. Do you know if i can generate a file with this ?

[former_member590735]

Thanks Sergei. I guess i have to open a session before ... Isn'it ?

[former_member390407]

Hi Jeremie,

What exactly do you need (item master data?)? What field do you mean by "Status"?

You can send a get request to Items resource and apply a $select query string for necessary fields.

Something like:

https://address:50000/b1s/v1/Items?$select=ItemCode, ItemName, AssetStatus